changing a value to percentage

[Anonymous]

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%?

[kcantor]

@Anonymous 

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

[Kalpavruksh]

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.

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may add custom column as follows.

Value.Divide([Column2], List.Sum(#"Changed Type"[Column2]))

[ZunzunUOC]

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

You must use the brackets correctly. Try it