Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register 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 ])
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
11 | |
10 | |
9 | |
8 |
User | Count |
---|---|
17 | |
12 | |
11 | |
11 | |
11 |