Forum Discussion
Filtering Dates help in Power Query please!
Hello threw001 ,
Use the following M code to create the column for filtering, This code calculates the date 30 days before today
DateTime.LocalNow() - #duration(30, 0, 0, 0)
After creating this custom column, filter the date field by choosing dates that are less than or equal to the result of the formula
Table.SelectRows(#"Previous Step", each [Date] <= Date.From(DateTime.LocalNow() - #duration(30, 0, 0, 0)))
by this your data will dynamically filter to include all records with a date on or before 30 days from the current date, regardless of when the report is run
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Hello threw001 ,
Use the following M code to create the column for filtering, This code calculates the date 30 days before today
DateTime.LocalNow() - #duration(30, 0, 0, 0)
After creating this custom column, filter the date field by choosing dates that are less than or equal to the result of the formula
Table.SelectRows(#"Previous Step", each [Date] <= Date.From(DateTime.LocalNow() - #duration(30, 0, 0, 0)))
by this your data will dynamically filter to include all records with a date on or before 30 days from the current date, regardless of when the report is run
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
dharmendars007 thanks - that worked perfectly!