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 a...
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
)

     

     

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
)

 

 

rainchong7401's avatar
rainchong7401
Helper III
3 years ago

Kamsahamnida hyung. 
Really appreacited your respond.