Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Is there is any code by which i can pick the last payment date of payment date column?
Payment Date | Entry No_ | Cust_ Ledger Entry No_ | Entry Type | Posting Date | Document Type | Document No_ | Amount | Amount (LCY) | |
5/14/2008 0:00 | 532 | 295 | 2 | 5/13/2008 0:00 | 1 | JV/08/MAY/00003 | -13483.2 | -13483.2 | |
5/14/2008 0:00 | 538 | 295 | 2 | 6/24/2008 0:00 | 1 | BRV/APR08/00063 | -13483.2 | -13483.2 | |
5/18/2008 0:00 | 542 | 295 | 2 | 5/13/2008 0:00 | 1 | BRV/APR08/00025 | -11700 | -11700 | |
5/18/2008 0:00 | 544 | 295 | 2 | 5/13/2008 0:00 | 1 | JV/08/MAY/00003 | -1783.2 | -1783.2 | |
5/18/2008 0:00 | 550 | 295 | 2 | 6/24/2008 0:00 | 1 | BRV/APR08/00063 | -13483.2 | -13483.2 | |
5/18/2008 0:00 | 535 | 295 | 2 | 5/13/2008 0:00 | 1 | JV/08/MAY/00003 | 13483.2 | 13483.2 | |
5/18/2008 0:00 | 540 | 295 | 2 | 6/24/2008 0:00 | 1 | BRV/APR08/00063 | 13483.2 | 13483.2 | |
5/19/2008 0:00 | 546 | 295 | 2 | 5/13/2008 0:00 | 1 | JV/08/MAY/00003 | 1783.2 | 1783.2 | |
5/19/2008 0:00 | 548 | 295 | 2 | 5/13/2008 0:00 | 1 | BRV/APR08/00025 | 11700 | 11700 | |
5/19/2008 0:00 | 1535 | 295 | 2 | 6/24/2008 0:00 | 1 | BRV/APR08/00063 | 13483.2 | 13483.2 | |
Solved! Go to Solution.
Hi @Satish_Kumar,
Please check if the following steps return your desired result.
1. Create a measure named Maxpaymentdate using the following formula.
Maxpaymentdate = CALCULATE(MAX(Sheet1[Payment Date]),ALLEXCEPT(Sheet1,Sheet1[Cust_ Ledger Entry No_]))
2. Create a column named Delay using the following formula.
Delay = IF([Maxpaymentdate]<Sheet1[Posting Date],DATEDIFF([Maxpaymentdate],Sheet1[Posting Date],DAY),1*DATEDIFF(Sheet1[Posting Date],[Maxpaymentdate],DAY))
3. Create a table visual as follows.
However, if the above steps don't help, please post your expected result here.
Thanks,
Lydia Zhang
If u want nly max date use MAX , or do u want some other operation pls clarify dude.
I have to select the last payment date from the Payment Date Column.
See i have a to calculate the delay in payment from the posting date so for this i have to calculate the payment date and for the payment date i have instructed to take the last apymennt date against the payment ,
If you help me help me out.
Hi @Satish_Kumar,
Please check if the following steps return your desired result.
1. Create a measure named Maxpaymentdate using the following formula.
Maxpaymentdate = CALCULATE(MAX(Sheet1[Payment Date]),ALLEXCEPT(Sheet1,Sheet1[Cust_ Ledger Entry No_]))
2. Create a column named Delay using the following formula.
Delay = IF([Maxpaymentdate]<Sheet1[Posting Date],DATEDIFF([Maxpaymentdate],Sheet1[Posting Date],DAY),1*DATEDIFF(Sheet1[Posting Date],[Maxpaymentdate],DAY))
3. Create a table visual as follows.
However, if the above steps don't help, please post your expected result here.
Thanks,
Lydia Zhang
Max( Date)
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |