Forum Discussion

Dimitris_Kats's avatar
Dimitris_Kats
Helper V
4 years ago
Solved

Error with DateAdd

Dear members Hello   I am calculating the Current Month Sales amount: CM Sales = CALCULATE(SUM(Sales[Sales])) Also the Previous Month Sales PM Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(Time[M...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Dimitris_Kats ,

     

    Try to sumx your original measure to get correct result in total.

    PM Sales with correct Total = SUMX(VALUES('Time'[Month]),[PM Sales])
    Sales Dif with correct Total = SUMX(VALUES('Time'[Month]),[Sales Dif])

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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

     

Dimitris_Kats's avatar
Dimitris_Kats
Helper V
4 years ago

So, I used PREVIOUSMONTH with the month column of my calendar table and the PM Sales (PM Sales = CALCULATE(SUM(Sales[Sales]), PREVIOUSMONTH (Time[Month])) works well and i don't get an error when i am changing the time periode on the slicer.

The only problem now is that i get either wrong row total or no row total at all.

Do you know can i fix this?? I am sooooo close!!

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Dimitris_Kats 

    Sorry just noticed your reply. Would you pleas share a screenshot of you date table?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Dimitris_Kats ,

     

    Try to sumx your original measure to get correct result in total.

    PM Sales with correct Total = SUMX(VALUES('Time'[Month]),[PM Sales])
    Sales Dif with correct Total = SUMX(VALUES('Time'[Month]),[Sales Dif])

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

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