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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

YTD & YTG calculation with new header

I am trying to calculate YTG and  YTD calculation  like new header  2022-2021 ,2023-2022,2024-2023,2025-2024.I have posted sample Data for reference 

 

(previousyear -Currentyear)/Currentyear

 

Region      Date        -    Year                      Value        

west        Jan-2021       2021                        250

west        Jan-2022       2022                        350

west        Jan-2023       2023                        420

west        Jan-2024       2024                        460

west        Jan-2025       2025                        440

 

Expected Output :       

                                            '

2022-2021           40%

2023-2022          -17%

2024-2023           -9%

2025-2024           5%

 I want to show above result in the Group .

 

Looking for support . thanks in  advance

 

 

2 REPLIES 2
Anonymous
Not applicable

@amitchandak  created the column  when i was apply the column its not showing the value .  when i use orignal column use its showing the value 

amitchandak
Super User
Super User

@Anonymous , You have to create a new column

 

Year name = [Year] & "-" &[Year] -1

 

and measure like diff % can be used

 

//Only year vs Year, not a level below

This Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('Table'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))
diff = [This Year]-[Last Year ]
diff % = divide([This Year]-[Last Year ],[Last Year ])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.