Hi,
Jus been watching rolling monthly total video where ;
< Moving X Month Avg:=CALCULATE(AVERAGE(MAT[Units]),
DATESINPERIOD(MAT[Date],LASTDATE(MAT[Date]),-1,MONTH)) >
so as the calculate make a row context (at least it seems to) for LASTDATE, if thought it shouldn't make a difference if you
use FIRSTDATE, and I do get the same results in a pivot table, but the actual 'measure totals' in measure grid are quite different.
Can someone help to explain what's actually happening.
Richard.
Bookmarks