Forum Discussion

rainchong7401's avatar
rainchong7401
Helper III
3 years ago
Solved

How to Rank without the same ID

Hi Friends,
How do I do ranking within the same vouchers & find the latest accountnum I have.
As expected output shown in the picture.
I want to do it in "Data" add column and add it in.
Kindly assist me and provide code if can.
Really thank you.

 

 

 

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please try something like below.

    Please check the below picture and the attached pbix file.

     

     

     

    Rank CC =
RANKX (
    FILTER ( Data, Data[Voucher] = EARLIER ( Data[Voucher] ) ),
    Data[AccountNum],
    ,
    DESC
)

     

     

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    Please try something like below.

    Please check the below picture and the attached pbix file.

     

     

     

    Rank CC =
RANKX (
    FILTER ( Data, Data[Voucher] = EARLIER ( Data[Voucher] ) ),
    Data[AccountNum],
    ,
    DESC
)