Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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
| User | Count |
|---|---|
| 52 | |
| 35 | |
| 22 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 39 | |
| 21 | |
| 21 |