Dax formula for cumulative - can't get it to show cumulatives in no change months

abalserv

New member
Joined
Aug 19, 2013
Messages
1
Reaction score
0
Points
0
hi Folks
I got some help to create this formula - I need a formula to show cumulative month on month and this works beautifully for months where there is data.

if(sum(SLA_Source[sla_net_accounted])<>0,Calculate(sum(SLA_Source[sla_net_accounted]),
DATESBETWEEN(Acc_Dates[AccDate],FIRSTDATE(all(SLA_Source[gl_date])),
LASTDATE(SLA_Source[gl_date]))),blank())


However for months where there is no movement, it just shows a blank :-( whereas what I want it to show is the previous month's cumulative...
eg.
Jan actual
100
January cumulative
100
Feb actual
50
February cumulative
150
March actual
blank
March cumulative
Blank - whereas I want it to show 150 as well...

Thanks for your help in advance...

Anne




It works beautifu
 
Back
Top