How to use Power quary to filter date more then 1 may 2022 ?

[admin11]

Hi All

I have a PBI sample file . Can some one share with me how to filter date > 1 May 2022 ?

My Sample PBI :-

https://www.dropbox.com/s/dka9zhuq0ksqhu8/test%20filter%20more%20then%20may.pbix?dl=0

Paul

[v-shex-msft]

Hi @admin11,

Did you mean to create a dynamic date filter in your query table?
If that is the case, you can apply a filter on your date field, then you can manually change the generated filter steps and parameterized the filter conditions with date functions and 'DateTime.LocalNow'.

Static filter:

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] > #date(2022,5,1))

Dynamic filter:

#"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] > #date(Date.Year(DateTime.LocalNow()),Date.Month(DateTime.LocalNow()),1))

Date functions - PowerQuery M | Microsoft Docs

DateTime.LocalNow - PowerQuery M | Microsoft Docs

Regards,

Xiaoxin Sheng

[amitchandak]

@admin11 , Click on the column or right-click, GO to filter option, then use custom, and then you will get an option to provide date filter with on or after , use that with date you want

refer

https://support.microsoft.com/en-us/office/filter-data-power-query-b5610630-f5bf-4ba4-9217-a628f9b89...

[admin11]

@amitchandak 

I try unable location filter by date. When I click on date column. My application I don't allow create new column date.

hope you can advise me.

Paul