I've been trying to write a measure to give me an index; I've got it working but could do with some help also If anyone would like to suggest aa better method please do.
my initial attempt was ;
Using ALL(Table1[Date], but this gave the number 1 for each 'row', but by using![]()
TableDate CountofRows := CALCULATE ( COUNT ( 'Calendar'[Date] ), FILTER ( ALL ( Table1[Date] ), Table1[Date] <= MAX ( Table1[Date] ) ) )
, it works fine, I have uploaded the work book showing both examples.![]()
ALL( Table )
Richard
Bookmarks