Cumulative value between two dates

[PGDEV]

Hello guys,

Someone can help me please ?

I want to cumulate NB of the last X months (in this example, I used 12 months).

Cumul = CALCULATE(SUM('12MoisGlissant'[NB]);DATESBETWEEN('12MoisGlissant'[M];'12MoisGlissant'[M-12];'12MoisGlissant'[M]))

I also tried DATESINPERIOD but I have the same results.

See below :

Thank you very much !

Have good day

[PGDEV]

I tried it but doesn't work :

Mesure = 
VAR MValue = SELECTEDVALUE('12MoisGlissant'[M])
VAR M12Value =  SELECTEDVALUE('12MoisGlissant'[M-12])
RETURN
calculate(SUM('12MoisGlissant'[NB]);filter('12MoisGlissant';DATESBETWEEN('12MoisGlissant'[Début de mois];M12Value;MValue)))

[PGDEV · Accepted solution]

I find a solution :

Cumul = 
VAR MValue = '12MoisGlissant'[M]
VAR M12Value =  '12MoisGlissant'[M-12]
RETURN
calculate(SUM('12MoisGlissant'[NB]);filter('12MoisGlissant';and('12MoisGlissant'[Début de mois]<=MValue;'12MoisGlissant'[Début de mois]>=M12Value)))