Cummulative difference using DAX

[kasebast]

Hi,

I need to get a table like this so i can give a line plot for the cummulative diiference. Can anyone help me with this? Actual coloumn will be given Drill_down we have to calculate.

Actual	Drill down_Actual
	7
1	6
1	5
0	5
0	5
0	5
2	3

Zero or blank values are taken as 1 to get the cumulative sum(i.e 7) but while subracting it is taken as zeroes only.

[Greg_Deckler · Accepted solution]

Seems to me that you are going to need an Index column and then you could use EARLIER in DAX. See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[kasebast]

Thanks a lot for the link. It was really helpful.