Forum Discussion

Jyo27's avatar
Jyo27
Helper II
2 years ago
Solved

Create Dynamic index column based on Date selection

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)
DateIndex
11/4/2023 14:121
11/4/2023 17:072
11/4/2023 18:493
11/5/2023 14:124
11/5/2023 17:075
11/5/2023 18:496

 

Appreciate your help .

  • amitchandak's avatar
    amitchandak
    2 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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

  • Jyo27's avatar
    Jyo27
    Helper II
    2 years ago

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