Dynamic date filter in power query

[Mannai]

Hello everyone,

So i'm getting my data from sql server, i have column date which contains dates from 1 january 2022 to 31 december 2022 i'm looking forward to do a dynamic filter so i can get only the dates that are superior to the current date.

How can i do it 
thank you

[amitchandak · Accepted solution]

@Mannai , Go and add any custom date filter >= 

Then go and replace that date with DateTime.Date(DateTime.LocalNow())

or

DateTime.Date(DateTime.FixedLocalNow())

You have to open advance editor and do that. Option on right click of table/Query