Hi,
Workbook and examples attached.
I've managed to write a calculated column to give an index by group,
based on the date within each group;
CALCULATE( COUNT(SortedT[Date]) ,
FILTER(ALL(SortedT ) , SortedT[Date] <= EARLIER(SortedT[Date]) &&
SortedT[Customer] = EARLIER(SortedT[Customer]) ))
But I've been tryin to do a measure that would do the same in a pivot table? any suggestions? Yes, a dangerous question
The straight forward index is ;
IndexM:=VAR Mdate = MAX(Table1[Date])
RETURN
CALCULATE([CountR],FILTER(ALL(Table1) ,Table1[Date] <= Mdate) )
The Table with the Index column for is SortedT
Richard
Bookmarks