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

FlaF's avatar
FlaF
Icon for Helper I rankHelper I
8 years ago

Hi,

In edit query, you can filter your data. You have to click on the column fsaledate and select only the last 3 months

 

Regards

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

    How 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's avatar
      Stachu
      Icon for Community Champion rankCommunity Champion
      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

    • FlaF's avatar
      FlaF
      Icon for Helper I rankHelper I
      8 years ago

      Yes I understand and you're right. I haven't explain it very well. You can enter in edit query mode and click on your column, then you can find the voice "date filters" in the drop-down menu of the column: "date filters" --> "Quarter" --> "Last quarter"