Forum Discussion
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...
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
Is it possible to show both date and time in a Date range slicer .(Slicer settings Between)