The total in a measure is different than expected

DAX DAX Calculations
2

Hello @pedroccamara,

Thank You for posting your query onto the Forum.

You can try the formula given below -

Sales LY = 
SUMX(
   SUMMARIZE( Dates , Dates[Year & Month] , "Last Year Sales" , [Sales LY] ) , 
"Last Year Sales" )

I’m also providing a link below where one of our expert @Greg had created a post which addresses specifically this issue.

Hoping this helps you. :slightly_smiling_face:

Thanks & Warm Regards,
Harsh

1 Like