Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Jyo27
Helper II
Helper II

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 .

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Jyo27
Helper II
Helper II

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

amitchandak
Super User
Super User

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.