Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply

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 supports this filter.  Should this be done on the in advance editor? 

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

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

vicky__0-1710452663765.png

 

View solution in original post

1 REPLY 1
vicky_
Super User
Super User

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

vicky__0-1710452663765.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.