Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Problem whit LTM

Hello, I want to use this structure but dynamically; HH_for = CALCULATE ([High + white + low F]; 'TRAINING' [PERIOD] = 201903 || 'TRAINING' [PERIOD] = 201902 || 'TRAINING' [PERIOD] = 201901 || ...
Need Help
Tutorial Requests
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

It seems like you need to achieve rolling total of previous 12 months? Could you share some sample data and clarify more details?

 

Regards,

Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    initial relationship1. This is the result you should get. 2. HH_for as we see the result is approachingUsing Datesinperiod -12 Monththis option I get the correct results but in a static way. option dynamically?Relationship option 2Results2º EJample