Forum Discussion
Solved
Convert In-Place, no new column, Decimal to Percentage
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 |
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.
2 Replies
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!
