Forum Discussion

Richard76's avatar
Richard76
Helper II
7 years ago

Cumm totals

Hi , after numerous attempts I have finally got my cumm budget calculation working (to a degree) . Issue now is the total at the bottom which obviously adds up all the individual days. How can I mak...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Richard76 ,

 

You may modify your issue using DAX like pattern below:

 

Cumn Budgets =
CALCULATE (
    [Budget Allocation] * SUM ( Time[YearWdays] ),
    ALLSELECTED ( Table )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Richard76's avatar
Richard76
Helper II
7 years ago

v-yuta-msft 

Hi thanks for your help but this doesnt seem to help. The totals on the bottom of the table still add up all the individual 'cumm budgets' per day.