Forum Discussion
Rolling Quarters
Hello, I'm fairly new to PBI Desktop and I'm struggling with a "rolling quarter" implementation in PBI... I have 4 graphs that show the status progess of Data Subject implementation in our datab...
Anonymous - In your Date table, you can add a "Relative Quarter" column, which will indicate "how many quarters ago" any date falls into. You will need to apply some logic to determine what is the most recent closed quarter. Then, in your visuals, you can filter based on the relative quarter.
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
I also appreciate Kudos.