Forum Discussion

kdixon5490's avatar
kdixon5490
Icon for Helper III rankHelper III
8 years ago
Solved

Dynamic 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...
Need Help
Show and Tell
  • Stachu's avatar
    Stachu
    8 years ago

    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