Dynamic Rolling Measures

[STG_Michael]

Good Afternoon!

I am needing to create some rolling calculations for a lot of measures... at least 75... closer to 100.

Below is a screenshot of some examples.

A few questions:

1. Do I have/need to create a measure for each rolling measure... including Current Month, Prior Month, YTD?
2. Is there a way to make it so I don't have to do #1?

Thanks!

- Michael

[dax]

Hi STG_Michael,

If you want to show current month, prebious Month, R3M, R6M  in table at the same time, I think you need to create measures for each rolling calculations.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[STG_Michael]

There's got to be a better way to do this.

Otherwise, I am creating hundreds and hundreds of measures...