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
Stachu
Community Champion
Community ChampionThis should work:
= Table.SelectRows(dbo_DATA_Sale, each Date.IsInPreviousNMonths([[FSaleDate]], 3))
although the error indicates that you try to filter a table rather than a table column - when you filter [FSaleDate] manually for e.g. last month, how does the syntax look like?