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 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)
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |