Find Transaction Number

[samihuq]

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

[anderson]

nice blog this is very intresting blog i am thanks ful to you click here

[v-jiascu-msft]

Hi @samihuq,

What's your expected result? Rank customers by Payment_Amount? 

Best Regards,

Dale

[samihuq]

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]

@samihuq

It works with your sample data.

What results did you get

[afzalphatan]

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]

Unfortunately it did not solve my problem..

[Zubair_Muhammad · Accepted solution]

Hi @samihuq

Try this Column

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