Forum Discussion
Solved
Formula Help!!
Basically, we have this huge dataset with individual line items for every transaction which includes prj info, budget, fiscal year etc. First, we need a formula to get the cumulative spent by budget ...
Hi , ChloeDL
Is this result you want to achieve?
you just need to create two new columns:
sum = CALCULATE(SUM('Table'[actuals]),FILTER(ALL('Table'),'Table'[actuals]<=EARLIER('Table'[actuals])))value = 'Table'[TBbudget]-'Table'[sum]This is my testing PBIX file.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , ChloeDL
Is this result you want to achieve?
you just need to create two new columns:
sum = CALCULATE(SUM('Table'[actuals]),FILTER(ALL('Table'),'Table'[actuals]<=EARLIER('Table'[actuals])))
value = 'Table'[TBbudget]-'Table'[sum]
This is my testing PBIX file.
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly