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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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!