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
)
samihuq's avatar
samihuq
Helper III
8 years ago

Hi,

Every Day My Customers Pays for my service. So i have a table of transactions. Now i need to identify the trasaction % received from my first time customer vs from existing customer. For that i need to rank the payment as first transaction or second transaction by the respective customer,

 

Hope it answers your query.

 

Thanks,
Sami 

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

samihuq

 

It works with your sample data.

 

What results did you get