Forum Discussion
Date filter except last 6 days
I want to automatically create a date filter that always disregards the last 6 days. For example, I have a database for the last 30 days and I want to get the data disregarding the last 6 days. For...
= Table.SelectRows(PriorStepOrTableName, each [Date] < Date.AddDays(Date.From(DateTime.LocalNow()), -6))
--Nate
Hi Anonymous
Didn't work. The expression error in "PriorStepOrTableName"
Do you have any other suggestions?
Tks
Hi Anonymous
With "PriorStepOrTableName" Anonymous is referring to the name of the prior step/table in your coding. Hope this helps!
