Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hey Everyone,
I am trying to create a measure to calculate a cumulative total in of a summerized table. I created a measure called "Cumulative Budget" to get the cummulative totals of the budget column but it doesn't seem to work. My desired result is to get 10,800 for 8/31, 34,560 for 9/30 and so on.
Here's the link to the test file: https://drive.google.com/file/d/1zrqIqMyksFj-x6hggzSKKP9Xae_sIKMf/view?usp=sharing
Any help is appreciated. Thanks!
Solved! Go to Solution.
Hi @akkitek
Try this code:
Budget Running Total =
CALCULATE(
SUM('Baseline_Variance'[Budget]),
FILTER(
ALLSELECTED('Baseline_Variance'[Baseline End Date]),
ISONORAFTER('Baseline_Variance'[Baseline End Date], MAX('Baseline_Variance'[Baseline End Date]), DESC)
)
)
Hi @akkitek
Try this code:
Budget Running Total =
CALCULATE(
SUM('Baseline_Variance'[Budget]),
FILTER(
ALLSELECTED('Baseline_Variance'[Baseline End Date]),
ISONORAFTER('Baseline_Variance'[Baseline End Date], MAX('Baseline_Variance'[Baseline End Date]), DESC)
)
)
This worked! Thanks!
Check out the November 2023 Power BI update to learn about new features.