In response to Richard Buttney, same questiong but I've attached the file, jus to not there are some
Excel fromulas, but it's the diffence between first and last date in the measure gird that's of interest.
< 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.
As you'll see lastdate returns 5.5 and fist 10, but both behave the same in a p table
Can someone help to explain what's actually happening.
Richard.
Bookmarks