Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |