Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 )
Check out the November 2023 Power BI update to learn about new features.