cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Partisan

## 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
Post Partisan

@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

Super User

@THENNA_41 , 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 ])

Announcements

#### Power BI Monthly Update - November 2023

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

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors