DAX cumulative total Column using Not using 'earlier'

[dicken]

Hi,
Does anyone know how to do a cumulative total for a column not measure and not using "EARLIER', so
the same result as

 CALCULATE([Tunits], FILTER(ALL(Table13),Table13[Date] <=EARLIER(Table13[Date])))

I've tried using

CALCULATE( MAX( Table[Date] ))

, which bring back the date in the current row context but even when using this as a
helper column I still get a circular dependency.


RD

 

[RoryA]

and not using "EARLIER'

Why would you not use EARLIER?

 

[dicken]

Why would you not use EARLIER?

Because I'd like to know how, I found this on using 'Earlier' in a measure ;

EalrierM:=CALCULATE([Totalrevenue],
                      FILTER(ALL(FSales),
                                  SUMX(FILTER(FSales,EARLIER(FSales[Date])<= FSales[Date]),FSales[Sales]) ))

https://javierguillen.wordpress.com/2012/02/06/can-earlier-be-used-in-dax-measures/

I'm still not sure how this is working, two things especially, even though the use of Filter(Table, Earlier(Table[date] and also
the fact that in this case the revenue measure uses multiple tables, so is figure being returned, the SUMX is using just the
Fsales table sales figures.
if you have any thought in either matter let me know.

Richard.