Solved: Convert In-Place, no new column, Decimal to Percen...

ovetteabejuela · ‎08-23-2017

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

MarcelBeug · ‎08-23-2017

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.

Specializing in Power Query Formula Language (M)

MarcelBeug · ‎08-23-2017

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.

Specializing in Power Query Formula Language (M)

ovetteabejuela · ‎08-23-2017

First suggestion didn't work but the second did... Thanks Marcel!

Convert In-Place, no new column, Decimal to Percentage