Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 .
Solved! Go to 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
Is it possible to show both date and time in a Date range slicer .(Slicer settings Between)
@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
User | Count |
---|---|
85 | |
80 | |
76 | |
49 | |
41 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |