HI,
I wanted to create a number sequence with dax , so started with ;
Onevalue:=IF( HASONEVALUE(Table1[Date]),VALUES(Table1[Date]))
I then used this in another measure ;
Index :=
CALCULATE (
COUNTROWS ( Table1 ),
FILTER ( ALL ( Table1 ), ISONORAFTER ( Table1[Date], [Onevalue]...