Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Power Query, Is there anyway to convert a number to a percentage without adding a new column?
Sample Data:
Convert to Percentage |
100 |
50 |
31 |
87 |
Solved! Go to Solution.
You can just adjust the data type, e.g. via the data-type-button in the column header (at the left).
Otherwise, various options on the "Transform" tab adjust data without adding a column.
So if you need to divide the results by 100, go to the Transform tab - Standard - Divide.
You can just adjust the data type, e.g. via the data-type-button in the column header (at the left).
Otherwise, various options on the "Transform" tab adjust data without adding a column.
So if you need to divide the results by 100, go to the Transform tab - Standard - Divide.
First suggestion didn't work but the second did... Thanks Marcel!