Divide Multiple Columns in Power Query by 100 in mass to be able to display % correctly.

[Anonymous]

Trying to figure out how I can select multple columns at once in power query and divide by 100 to when i convert the columns to percentages, they display correctly. 

Thank you!

Markets	Periods	Products	$ / $MM ACV % Chg YA	$ / TDP % Chg YA	$ % Chg YA	Any Disp EQ Price % Chg YA
West Mass	YTD YA - 9 w/e 02/29/20	G	-17.253	20.54	-17.041	15.306
West Mass	YTD YA - 9 w/e 02/29/20	F	4.297	7.763	6.407	-37.673
West Mass	YTD YA - 9 w/e 02/29/20	E	6.515	-14.499	4.349	10.801
West Mass	YTD YA - 9 w/e 02/29/20	D	-1.557	14.637	-2.717	-30.893
West Mass	YTD YA - 9 w/e 02/29/20	A	18.639	3.867	16.076	0.765
West Mass	YTD YA - 9 w/e 02/29/20	B	4.146	4.417	5.506	-88.72
West Mass	YTD YA - 9 w/e 02/29/20	C	5.522	-0.798	7.791	68.067

[steverugi]

1 select columns you want to divide
2 use from the ribbon any available transformation (like rounding) and check the M formula text
3 replace 'each Number.Round(_, 2)' with 'each _/100' like the following:
= Table.TransformColumns(#"Replaced Value",{{"11:01:00", each _/100, type number}, {"11:01:00", each _*100, type number}, {"blinding ", each _/100, type number}})

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Don't know how to do this without resorting to some complicated hand coding of M.

You'd be as well of to select the columns one by one in the editor then from Transform-> Standard select Divide, and enter 100.

Regards

Phil

[Guardian_King]

Hi @PhilipTreacy. , 

 

I have to divide numbers with 2 digits by 100 (Example - 25) and with 1 digit by 10 (Example - 5) in same column. I have attached a img for reference.

Please do you have any way out? 

Thanks & Regards

Kishlay Kumar