Problem whit LTM

[Anonymous]

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)

[v-yuta-msft]

@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]

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

[amitchandak]

What is the exact problem, not very clear from the description?