Running total measure month by month using 'Earlier'.

[dicken]

Hello,
I've been trying to write measure to give running total month by month using the 'Earlier' function rather than a variable;

This works;

< RTM:=VAR sdate = MAX(dtable[Date]) RETURN

CALCULATE(SUM(dtable[Price]),dtable[Date]<=sdate && dtable[Date]> EOMONTH(sdate,-1)) >

This doesn't , I do have it working as a calculated column.


< Newtoo:=CALCULATE( SUM(dtable[Price]) , dtable[Date]<=EARLIER(dtable[Date])
&& dtable[Date] > EOMONTH(EARLIER(dtable[Date]),-1)) >

I'd like to know where I'm going wrong?

Richard.

 

[RoryA]

It's all about context, as it usually is with DAX. This blog post explains it in great detail: Can EARLIER be used in DAX measures?

 

[dicken]

It's all about context, as it usually is with DAX. This blog post explains it in great detail: Can EARLIER be used in DAX measures?

Thanks Rory,
In a way it's nice to know that it's not straight forward, but I'll certainly try the method suggestted.

Richard.