topic Re: Cumulative value between two dates in Developer

Cumulative value between two dates

PGDEV — Wed, 19 Sep 2018 11:54:20 GMT

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

Re: Cumulative value between two dates

PGDEV — Wed, 19 Sep 2018 11:53:42 GMT

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)))

Re: Cumulative value between two dates

PGDEV — Wed, 19 Sep 2018 14:06:01 GMT

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)))