Forum Discussion
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 ...
lbendlin
Super User
Super Userhere'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