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

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.

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"