Forum Discussion
Solved
Cumulative value between two dates
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
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)))
2 Replies
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)))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)))