Forum Discussion

STG_Michael's avatar
STG_Michael
New Member
6 years ago

Dynamic Rolling Measures

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

Need Help

2 Replies

  • dax's avatar
    dax
    Community Support
    6 years ago

    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's avatar
      STG_Michael
      New Member
      6 years ago

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

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