Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
@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
@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 ])
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 9 | |
| 9 | |
| 8 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 20 | |
| 20 | |
| 17 | |
| 14 | |
| 14 |