Forum Discussion

Helper I

4 years ago

Solved

Dynamic 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 onl...

Tips and Tricks

Tutorial Requests

amitchandak
4 years ago
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

Super User

4 years ago

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