LY calculation wrong total

[Mous007]

Hi all,

I had the table below intially as my output;

And since i only want to show and calculate LY data up to the October (since my CY data is only available untill Oct) i used the following dax:

LY Consumption  = IF(ISBLANK( [CY Consumption]) , BLANK(),

Calculate([CY Consumption],DATEADD('Dates table'[Date] , -1 , YEAR))

And the output of the table become as follow:

 

The problem i have is that i am still summing ALL the values from Last year and the total is still the same (including Nov + Dec) and my % calculation is still picking up to total sum of last year.

Any body to tell me what i am doing wrong with my calculation? and how i can fix it please?

Wishing you all a merry Xmas 😃

Thank you in advance

[Mous007]

Perfect thank you.

& happy new year in advance 🙂

[amitchandak · Accepted solution]

@Mous007 , Change the measure like this and try

LY Consumption = sumx(values('Dates table'[Period]),IF(ISBLANK( [CY Consumption]) , BLANK(),
Calculate([CY Consumption],DATEADD('Dates table'[Date] , -1 , YEAR))))