Forum Discussion
Solved
Power Query: Filter Date
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 suppo...
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-isincurrentmonthOr 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