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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
lokesh2021
New Member

undefined

Hello all, I have created measure named P/c and I have a column named year which has 2021,2022,2023 and the year data type is in whole number.Now when I insert the created measure p/c with the year column, iam getting values like 2021-10.73, 2022-10.76, 2023-11.03 which are all in percentage. 

Now I need the variance like 2022-(minus)2021, 2023-2022. 

3 REPLIES 3
lucadelicio
Super User
Super User

Hi,
can you post:
 - the pbix
 - excel example dataset
 - the screen of the result that you want
 - the screen of the relationship model
Thank you!



Luca D'Elicio

LinkedIn Profile

IMG_20230703_151720.jpg

p/c is a measure which i have created and year is a column . In the sheet

IMG_20230703_151745.jpg

 Now I need the variance like 2022minus2021 2023 minus 2022

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.