RANKX issue

[odzelashvili1]

Hello PBI community 🙂

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

My table looks like this:

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?  

[amitchandak · Accepted solution]

@odzelashvili1 , Try a new column like

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

[odzelashvili1]

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?