Hi,
I’m trying to create a rolling TTM for Net Income and to store it by Quarter.
I’ve tried using a TTM by Switchover month metric, but that only gives me a single period of data at a time. However, I would like to show the TTM trend by quarter on a graph so I need to store the amounts by quarter.
Can anyone assist in the best approach for this?
Thanks in advance,
Jeff
Best answer by Min Li
Movingsum('17. Input Data'[by:Month.Quarter],4,0,Quarter)
'17. Input Data' is your original metric for net income by month.
+12
Movingsum('17. Input Data'[by:Month.Quarter],4,0,Quarter)
'17. Input Data' is your original metric for net income by month.
Awesome! Thank you!
I do have quite a few more modifiers in my formula but I was able to incorporate them to get the desired results.
Thanks so much!
Jeff
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
