Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
Hope you are all well.
I am getting incorrect values when calculating running balance which I need help with. Can you pls assist.
Running Balance Column calculation condition =
1. IF Debit/Credit Date < Todays Date, (Credit Limit - Amt) when Entry Type = ( "DEBIT and CREDIT)
2. IF Debit/Credit Date >= Todays Date, (Credit Limit - Amt) when Entry Type = "PENDING.
ID | Name | Credit Limit | Credit Limit Start Date | ENTRY TYPE | Debit/Credit Date | Amt | Running Balance |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 7th Nov 2022 | -1000 | 9000 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 15th Nov 2022 | -100 | 8900 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 7th Dec 2022 | -500 | 8400 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | CREDIT | 15th Dec 2022 | 500 | 8900 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 7th Jan 2023 | -600 | 8300 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 8th Jan 2023 | -200 | 8100 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | DEBIT | 10th Jan 2023 | -300 | 7800 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | PENDING | 15th Jan 2023 | 150 | 7800 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | PENDING | 20th Jan 2023 | 200 | 7800 |
1 | Joe Bloggs | 10000 | 5th Nov 2022 | PENDING | 23rd Jan 2023 | 0 | 7800 |
1 | Joe Bloggs | 20000 | 10th April 2023 | CREDIT | 15th April 2023 | 0 | 20000 |
1 | Joe Bloggs | 20000 | 10th April 2023 | DEBIT | 20th April 2023 | -200 | 19800 |
1 | Joe Bloggs | 20000 | 10th April 2023 | DEBIT | 20th April 2023 | -300 | 19500 |
1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | 30th April 2023 | 1000 | 20500 |
1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | 30th June 2023 | 1000 | 21500 |
1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | 30th July 2023 | 100 | 21600 |
1 | Joe Bloggs | 20000 | 10th April 2023 | PENDING | th Aug 2023 | 500 | 22100 |
Thanks,
Sekhar
Yes, date column is recognized as date data types.
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |