Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
I am looking to filter my data and display data for dates that are greater than of equal to 3 months prior (starting the first day of the month) or equal today. I'm not sure if the power query supports this filter. Should this be done on the in advance editor?
Solved! Go to Solution.
You can use the drop-down to filter with the conditions is in previous 3 months OR in this month.
If you're fine with writing it out yourself - the function docs are - https://learn.microsoft.com/en-us/powerquery-m/date-isinpreviousnmonths and https://learn.microsoft.com/en-us/powerquery-m/date-isincurrentmonth
Or through the below
You can use the drop-down to filter with the conditions is in previous 3 months OR in this month.
If you're fine with writing it out yourself - the function docs are - https://learn.microsoft.com/en-us/powerquery-m/date-isinpreviousnmonths and https://learn.microsoft.com/en-us/powerquery-m/date-isincurrentmonth
Or through the below
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 29 | |
| 27 | |
| 26 | |
| 24 | |
| 16 |
| User | Count |
|---|---|
| 53 | |
| 46 | |
| 38 | |
| 29 | |
| 21 |