cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataman123
Helper III
Helper III

changing a value to percentage

am looking to find the percentage of the column 'Count of Opps closing in days' in the below dataset. The issue i am having is when i use the below formula i am geeting percentages over 100%?

Capture.JPG

 

1 ACCEPTED SOLUTION

@dataman123 

 

You may add custom column as follows.

Value.Divide([Column2], List.Sum(#"Changed Type"[Column2]))
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
kcantor
Community Champion
Community Champion

@dataman123 

I would recommend creating seperate calculations to determine where the fault is. Sometimes, I actually have percentages greater than 100.

In fact, I think that your calculation may be flawed.

First, create your count of opps closing in days calculation. Then create a count of all opps in the company band (removing the filter for closed in days [I don't understand that logic as it is not my data]). Finally, use the DIVIDE function to complete the calculation. Drop all three in your table and see if the math lines up.

Right now, your calculation seems to be dividing a calculation by the sum of itself multiplied by 100. To me, a percentage would be the number of opps fitting the specified criteria divided by the number of opps (with no filter on specified criteria) and formatted as a percentage (multiplied by 100).





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

Proud to be a Super User!




Kalpavruksh
Resolver I
Resolver I

Hi,
It seems that there could be some issue with the formula. Make sure the brackets are in proper order. Alternatively, change the format of the column to "Percentage" instead of dividing the formula by 100.
 
Kalpavruksh Technologies | Microsoft Gold Partner
Denmark | USA | India | Germany

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@Kalpavruksh  @ZunzunUOC  i was hoping to do this as a powequery custom column? the formula works but not as a power query

@dataman123 

 

You may add custom column as follows.

Value.Divide([Column2], List.Sum(#"Changed Type"[Column2]))
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ZunzunUOC
Resolver III
Resolver III

@dataman123, you can get your answer in the other post.

 

You must use the brackets correctly. Try it Smiley Happy

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!