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

Thank you very much tamerj1  for your reply.

Unfortunatelly when i use the calendar date I don't get results at all.

I tried to use instead of the DATEADD the PREVIOUSMONTH but i don't get correct results and i don't get results by month.

 

I don't know what is wrong