Forum Discussion

samihuq's avatar
samihuq
Helper III
8 years ago
Solved

Find Transaction Number

Hi, I hav a Transaction Table with bellow structure:   Date Customer Payment_Amount  Payment_Count 1-Jan-17 Sami 10 1 1-Jan-17 Bayezid 10 1 1-Jan-17 Surkhru 10 1 2-Jan-17 Sami 10 2 2-Jan-17 S...
Need Help
Show and Tell
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi samihuq

     

    Try this Column

     

    =
RANKX (
    FILTER ( Table1, Table1[Customer] = EARLIER ( Table1[Customer] ) ),
    CALCULATE ( VALUES ( Table1[Date] ) ),
    ,
    ASC,
    DENSE
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi samihuq

 

Try this Column

 

=
RANKX (
    FILTER ( Table1, Table1[Customer] = EARLIER ( Table1[Customer] ) ),
    CALCULATE ( VALUES ( Table1[Date] ) ),
    ,
    ASC,
    DENSE
)