Forum Discussion
Formula for Correct Percent Conversion
Hi all,
I'm receiving a decimal number format coming out of my query into BI and it needs to be converted to a percentage. However, when I convert to %, it turns numbers to the left of the decimal point to hundreths ex. 6.99 gets converted to 699% (see below pics). Does anyone know the formula of how to correctly format this field so the conversion is face value?
Hi NCPowerBI
Is it an option for you to divide the column by 100 in Power Query?
If so, in Power Query go to the Transform tab and in the Number Column section, press Standard and select Divide.
3 Replies
Hi NCPowerBI
Is it an option for you to divide the column by 100 in Power Query?
If so, in Power Query go to the Transform tab and in the Number Column section, press Standard and select Divide.
That worked! Thanks brotha!
No problem. Glad it worked.
