cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
odzelashvili1
Helper I
Helper I

RANKX issue

Hello PBI community 🙂

 

I want to solve this with RANKX function, but i dont get correct output.

 

My table looks like this:

odzelashvili1_0-1631875123132.png

where I mannualy added "Rank" column, this is what I want to get in power bi.

 

Logic is this: for every visit_key, i want to rank this visit_keys by time.

 

Any ideas?  

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@odzelashvili1 , Try a new column like

 

rank = rankx(filter(Table, [visit_key] =earlier([visit_key]), [Time],,asc,dense)

 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@odzelashvili1 , Try a new column like

 

rank = rankx(filter(Table, [visit_key] =earlier([visit_key]), [Time],,asc,dense)

 

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

View solution in original post

Thank you, I tried something similar, but doesnt worked, now its working.

 

I have another question, if I want to filter my table with more than 1 argument, can i use CALCULATETABLE function instead of filter?

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors