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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

calculatation the % difference

I create a table like this in Power Bi. How would I calculate the % difference from this table  similar to the example? The information is found in four diff tables in the Power Bi model. 

For example: 

% Difference: (V1-V2)/[(V1+V2)/2]*100

1. (53-63)/[(53+63)/2]*100=10%

2. (63-53)/[63+53)/2]*100=17.24%

 

Help.png

 

2 REPLIES 2
Nathaniel_C
Super User
Super User

=(53-63)/((53+63)/2)*100 =-17.24

 

@Anonymous , your math in your example doesn't work. What are you doing with the brackets?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

It would be -14%. I'm trying to create a formula that would calculation the % difference within the Power Bi.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.