Forum Discussion
Custom column Index or Ranking by other column
Hi Team!!! I have a table with AccountReceived informations and Clients. I need to create a new custom column (like an Index) that define an order according the client column changed. I mean...
Hi my friend,
Can I bring to P.BI, my client table even it has half milion of records?
or How can I create a RANK measure in my table? I need to rank and show only all my 20 big clients
According to your description, you want to create a rank column which only increases when group changes. Right?
In this scenario, you can just use RANKX() to dense rank based on the group column, please refer to my sample below:
rank = RANKX(Query1,Query1[Table_DAX_sorting[name]]],,ASC,Dense)
Regards,