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?
Solved! Go to Solution.
What's your expected result? Rank customers by Payment_Amount?
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.
Below code in calculated column should do your job
Count = COUNTROWS(FILTER(Table1, Table1[Customer] = EARLIER(Table1[Customer]) && Table1[Date] <= EARLIER(Table1[Date])))
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.