Notifications
Clear all
Power Query
6
Posts
2
Users
0
Reactions
94
Views
Topic starter
I'm importing data from a spreadsheet that lists several instruments and all of the dates they were calibrated. I want to limit the results to show only the last 3 calibrations for each instrument. Can I do this in Power Query? Example data attached.
Posted : 19/07/2022 11:09 am
Probably yes, but you didn't include the file. After adding an attachment, don't forget to press the Upload button 🙂
Posted : 19/07/2022 2:30 pm
Topic starter
Got the attachment added.
I'm using Excel in Office 365 on a PC.
Posted : 19/07/2022 5:12 pm
Thanks for attaching the file. I've added some basic PQ code to it. See if that will work for you.
Posted : 19/07/2022 11:29 pm
Topic starter
This exactly what I needed. Thank you for the quick response and solution, Riny.
Posted : 20/07/2022 6:20 am
Glad I could help!
Posted : 20/07/2022 6:40 am
