How to filter your data to show only the rows for the last 3 months Power Query in Excel

Опубликовано: 15 Январь 2025
на канале: Celia Alves - Solve & Excel

10,730

We often need our reports to be “TIME-DYNAMIC,” meaning that the data to import needs to follow certain rules applied to the DATE in which we run our queries.

Power Query’s user interface offers plenty of options. In this video, we exemplify the “in the previous 3 months” requirement. I invite you to explore all the other options available in the “Date Filters” list, including the Custom Filter option.

Have you used the date filters before? Let me know of a business case where you applied that feature.

----------------------

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
YouTube -    / celiaalvessolveexcel
Facebook:   / solveandexcel
Instagram: @solveandexcel
LinkedIn:   / celiajordaoalves
LinkedIn:   / solveandexcel
Twitter: @celia_excel
Solve & Excel Consulting - https://solveandexcel.ca/
-------------------------

#Excel #solveandexcel #microsoft365 #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #canada

----------------------