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

Reply
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.

 

 

YearProductTotal Sales
2018Car200
2019Car345
2020Car64
2021Car654
2022Car456
2018Bike125
2019Bike560
2020Bike230
2021Bike238
2022Bike100

 

YearCar SalesYoY % ChangeBike SalesYoY % Change
2018200 125 
2019345 560 
202064 230 
2021654 238 
2022456 100 
2 REPLIES 2
ThxAlot
Super User
Super User

YoY Chg.pbix

 

ThxAlot_0-1692085502355.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



larsheinemann
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 Fabric Conference

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

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors