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 Surkhru 10 2

3-Jan-17 Bayezid 10 2

3-Jan-17 Surkhru 10 3

3-Jan-17 Tanim 10 1

 

I need to calulate the Payment_Count column, where i need to see the Rank of the transaction, first time, second time etc.

 

Can this be done?

 

Regards,

Sami

 

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
)

7 Replies

  • 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
)
  • afzalphatan's avatar
    afzalphatan
    Resolver I
    8 years ago

    Hi, 

     

    Below code in calculated column should do your job

     

    Count = 

COUNTROWS(FILTER(Table1, Table1[Customer] = EARLIER(Table1[Customer]) && Table1[Date] <= EARLIER(Table1[Date])))

     

    • samihuq's avatar
      samihuq
      Helper III
      8 years ago

      Unfortunately it did not solve my problem..

    • 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