Forum Discussion

sparker22's avatar
sparker22
Frequent Visitor
3 years ago

Relative date filter based on data end, not current date

I have a report that will be run monthly with a month delay. Each month I need to be able to show the latest 12 months (or similar) in the dataset.

Relative date filtering will not work for this as it looks at the current date, rather than the latest data in the set.

i.e. If the data runs up until the end of April-23 I will want to show Mar-22 til Apr23, but if the report is viewed in June, relative date will show Apr-22-May23 with no May data.

 

What is the best way to filter this without having to manually change dates?

 

Hopefully this makes some sense.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    here's a sample approach

     

    - create a string representation of your date column, replace the latest date with a string "Latest"
    - sort that new column by the original date column
    - add a slicer or visual/page/report level filter
    - set the filter to "Latest"
    - publish the pbix to the workspace/app