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 ||
'TRAINING' [PERIOD] = 201812 ||
'TRAINING' [PERIOD] = 201811 ||
'TRAINING' [PERIOD] = 201810 ||
'TRAINING' [PERIOD] = 201809 ||
'TRAINING' [PERIOD] = 201808 ||
'TRAINING' [PERIOD] = 201807 ||
'TRAINING' [PERIOD] = 201806 ||
'TRAINING' [PERIOD] = 201805 ||
'TRAINING' [PERIOD] = 201804)

Before suggesting other options, try the following:
HH_for = CALCULATE ([High + white + low F];
DATESINPERIOD ('TRAINING' (end_date); MAX ('TRAINING' (end_date)); - 12; MONTH)

Need Help
Tutorial Requests

3 Replies

  • 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