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

 

Need Help

3 Replies

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