Create Dynamic index column based on Date selection

[Jyo27]

Hi ,

Need help in creating dynamic Index column based on Date selection by user . 

Have created measure but im getting wrong result . 

Rank = RANKX(ALLSELECTED('Date'[Date]),CALCULATE(MAX('Date'[Date])),,ASC,Dense)

Date	Index
11/4/2023 14:12	1
11/4/2023 17:07	2
11/4/2023 18:49	3
11/5/2023 14:12	4
11/5/2023 17:07	5
11/5/2023 18:49	6

Appreciate your help .

[Jyo27]

Is it possible to show both date and time in a Date range slicer .(Slicer settings Between)

[amitchandak · Accepted solution]

@Jyo27 , You can not create an index column based on selected values. You have create

Use new Rank measure

rank = rank(dense, allselected(Table[Date]), orderby(Table[Date]) )

I have used Table[Date], as there timestamp and assumed you want order by that

or

rank = rank(dense, allselected(Date[Date]), orderby(Date[Date]) )

Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo