Make column into %

[Anonymous]

Hi, 

I have column that is in number format.

The data comes from sharepoint and which comes from Power Apps.

I would like to convert into a % (without having to change Power Apps or Sharepoint List)

Do i add New Measure, Do i add a New Column or Do i use Dax?

[Anonymous]

@Anonymous 

1. Open Transform Data, create a custom column from the top menu bar.

2. Remove the original column in power query.

3. Under home tab change the data type to percentage.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

hi, i had to reconnect my data source.

Objective is to get an average of the three audit scores and get into a percentage

I am still battling with all the responses. Is it because of the format of my Audit score columns?

[Anonymous]

You can create new measure calling same column and divide it by 100
Once measure is  created convert it into percentage.

Sample DAX = Max([Test])/100,
Click on % sign in measure tools to convert it to Percentage.

Hope this helps.

Thanks,
Ashwin Kulkarni

[Anonymous]

If it's not available in any of the mathematical transformations, then you can always use 'Add New Column' and perform the operation in there. Then remove the old column.

[Anonymous]

If in Power Query, just apply a transformation to the column: divide the value by 100.

[Anonymous]

Thanks, 

Where do i do that?

I clicked on Transform Data....