Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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
Proud to be a Super User!
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}})
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
Proud to be a Super User!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |