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...
  • 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

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