Forum Discussion
Solved
RANKX issue
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?
odzelashvili1 , Try a new column like
rank = rankx(filter(Table, [visit_key] =earlier([visit_key]), [Time],,asc,dense)
2 Replies
odzelashvili1 , Try a new column like
rank = rankx(filter(Table, [visit_key] =earlier([visit_key]), [Time],,asc,dense)
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?
