Forum Discussion

MrMP's avatar
MrMP
Helper III
3 years ago
Solved

Cumulative showing wrong figures

Hi everyone!

 

I am facing problems with cumulative calculations. Ive tried multiple formulas from the internet, quick measure. Nothing seems to fix the trick. As showed below, I need to have cumulative of the last column 11000 + 9900 = 20900 (and so on) but i keep geting 19.800 in that field.

I assume its the problem with Calc Cost column but cannot find the solution. 

Attaching pbix also

 

 

Thank you for your help!

 

Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    MrMP , Try like 

    Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(all('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative

or

Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(allselected('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    MrMP , Try like 

    Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(all('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative

or

Calc 7(cumulative of calc6) = CALCULATE(sumx(SUMMARIZE(Input,'Calendar'[Year],'Calendar'[Quarter]),[Calc 6]), filter(allselected('Calendar'), [Date]
 <=max('Calendar'[Date])))
//cumulative