cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

Announcements

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

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors