Forum Discussion
Group, rank and replace
Morning, I've attached a sample dataset, There's a few things I need it to be able to do: -I want to be able to rank them by SALES ORDER -Once ranked, I want to be able to show the names of ...
Hi Jamie-
as per my understanding, can you please try the below:
Rank_p =
IF (
NOT ISEMPTY ( table ),
RANKX (
CALCULATETABLE (
data,
ALLEXCEPT ( table, table[column] )
),
CALCULATE ( SELECTEDVALUE ( table[column] ) ),,
DESC,
Dense
)
)
Regards,
Rajendra
Thanks for trying,
but don't think this is close: