cancel
Showing results for
Did you mean:  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%? 1 ACCEPTED SOLUTION  Community Support

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.
5 REPLIES 5  Community Champion

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).

Proud to be a Super User!  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.  Helper III

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

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.  Resolver III

You must use the brackets correctly. Try it   