Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @samihuq
Try this Column
= RANKX ( FILTER ( Table1, Table1[Customer] = EARLIER ( Table1[Customer] ) ), CALCULATE ( VALUES ( Table1[Date] ) ), , ASC, DENSE )
Hi @samihuq,
What's your expected result? Rank customers by Payment_Amount?
Best Regards,
Dale
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
It works with your sample data.
What results did you get
Hi,
Below code in calculated column should do your job
Count = COUNTROWS(FILTER(Table1, Table1[Customer] = EARLIER(Table1[Customer]) && Table1[Date] <= EARLIER(Table1[Date])))
Unfortunately it did not solve my problem..
Hi @samihuq
Try this Column
= RANKX ( FILTER ( Table1, Table1[Customer] = EARLIER ( Table1[Customer] ) ), CALCULATE ( VALUES ( Table1[Date] ) ), , ASC, DENSE )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |