Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
71 | |
63 | |
57 | |
49 | |
46 |