Forum Discussion
Helper IDynamic date filter in power query
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
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
1 Reply
- amitchandak
Super User
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