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

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

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.