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