Forum Discussion
kdixon5490
Helper III
Helper IIIDynamic filters on Tables
Currently I have a table called data_sale that has all my sales done and this table can get very large. Here is what the Advance Editor under query has... let Source = Sql.Database("ORL-WKS-KDIXI...
if the column type is set to Date you should see date filters
formula generated is somthing like this:
= Table.SelectRows(#"Renamed Columns", each Date.IsInPreviousNMonths([MthDate], 3))
you would obviously adjust the names to your setup
kdixon5490Helper III
Helper IIIHow do I make it dynamic to always no matter what day I look at the report to always grab the last 3 months? Today's last 3 months is different than next weeks last 3 months.
I hope that makes sense.
Stachu
Community Champion
Community Championif the column type is set to Date you should see date filters
formula generated is somthing like this:
= Table.SelectRows(#"Renamed Columns", each Date.IsInPreviousNMonths([MthDate], 3))
you would obviously adjust the names to your setup