Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mous007
Helper IV
Helper IV

LY calculation wrong total

Hi all,

 

I had the table below intially as my output;

Mous007_0-1608567347979.png

 

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:
 
 
 
 
 
Mous007_1-1608567751061.png

 


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

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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))))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Mous007
Helper IV
Helper IV

Perfect thank you.

& happy new year in advance 🙂

amitchandak
Super User
Super User

@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))))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.