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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PBI_Chris67
New Member

How to calculate a % of achievement between two columns in a single table?

Hello,

 

I am new on the forum and would be very gratefull if some of you could tell me how to do something as simple a the calculation of a % of achievement between two columns from a single database.

 

So far, I just create a first column calcuating the difference between Column A & Column B, et's call it Call it Column C

And than I created another column with Column C / by Colonne A but the result is not accurate...

 

Thanks for your help !

 

 

 

 

2 REPLIES 2
JordanAWARE
Frequent Visitor

There is a chance you could be getting negative values which would definately cause some issues

 

try this:

 

Column C = Column A - Column B (like you already have)

New Percentage column = ABS(Column C) / Column A

 

then format this new column to be a percentage

 

If column B was larger than column A the number would be negative so ABS() gets the absolute value (ignores negatives) so that result in Column C will always be the difference between A and B

 

Greg_Deckler
Super User
Super User

Can you post some sample data and what you expect as a result?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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