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 there,
I am trying to figure out how to get the beginning (15 days ago) and end balance for a specific table.
If i select DepositDate of 11/15/2019 from the slicer. I would like to get the following:
EndBalance (123) = 61 -- (5+56) based on DepositDate
BeginningBalance(123) = 120 -- (55+65) based on ProcessDate = DepositDate - 15 days
BalanceType(A1 for 123) = 5 -- based on DepositDate
Same calculation for Account Number 345
AccountNumber | Type | Balance | DepositDate | ProcessDate |
123 | A1 | 5 | 11/15/2019 | 11/16/2019 |
123 | A2 | 56 | 11/15/2019 | 11/16/2019 |
123 | A3 | 65 | 10/25/2019 | 10/31/2019 |
123 | A4 | 55 | 10/24/2019 | 10/31/2019 |
123 | A5 | 45 | 10/30/2019 | 10/30/2019 |
345 | A1 | 54 | 11/15/2019 | 11/30/2019 |
345 | A2 | 5 | 10/1/2019 | 10/31/2019 |
345 | A3 | 45 | 10/3/2019 | 10/30/2019 |
I tried the following measure for BeginningBalance but i am getting blank.
= CALCULATE (SUM(table[Balance]), FILTER(table,table[processdate] = SELECTEDVALUE(table[DepositDate])-15)
Your help is very much appreciated!
Thank you
Glen
Solved! Go to Solution.
Hi Glen,
Here you go...PBIX
In the message it is right above my name. The formatting in those messages leave something to be desired.
Nathaniel
Proud to be a Super User!
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.