DAX Index Measure by group

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;

Please Login or Register  to view this content.

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 ;

Please Login or Register  to view this content.

The Table with the Index column for is SortedT

Richard