Skip to main content
cancel
Showing results for
Search instead 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

Anonymous
Not applicable

## Year on Year Percentage change

Hi folks,

I want to calculate Year on Year % change as per the below table. I want the YoY change to be calculated at the product level.

How can I achieve this ? Thanks in advance.

 Year Product Total Sales 2018 Car 200 2019 Car 345 2020 Car 64 2021 Car 654 2022 Car 456 2018 Bike 125 2019 Bike 560 2020 Bike 230 2021 Bike 238 2022 Bike 100

 Year Car Sales YoY % Change Bike Sales YoY % Change 2018 200 125 2019 345 560 2020 64 230 2021 654 238 2022 456 100
2 REPLIES 2
Super User

YoY Chg.pbix

 Expertise = List.Accumulate(        {Days as from Today},        {Skills and Knowledge},        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday))

Frequent Visitor

To calculate the Year on Year (YoY) percentage change for each product, you'd typically calculate the difference in sales between the current year and the previous year, then divide by the sales of the previous year.

``````YoY % Change =
VAR CurrentYearSales = TableName[Total Sales]
VAR PrevYearSales = CALCULATE(
SUM(TableName[Total Sales]),
FILTER(
TableName,
TableName[Product] = EARLIER(TableName[Product]) && TableName[Year] = EARLIER(TableName[Year]) - 1
)
)
RETURN
IF(
ISBLANK(PrevYearSales) || PrevYearSales = 0,
BLANK(),
(CurrentYearSales - PrevYearSales) / PrevYearSales
)``````

## Helpful resources

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 - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors