cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## LY calculation wrong total

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 😃

1 ACCEPTED SOLUTION
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))))

2 REPLIES 2
Helper IV

Perfect thank you.

& happy new year in advance 🙂

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors