Cumm totals

[Richard76]

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 make the total just equal the cumm budget up until the last day that is selected in the date filter ??

[v-yuta-msft]

@Richard76 ,

Could you show the dax expression of [Budget Allocation]? 

Regards,

Jimmy Tao

[v-yuta-msft]

@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]

@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.