Forum Discussion
Conditionally transform percentage to integer
In Power Query Editor, add a custom column with
if [id] = 12345 and Text.Contains([value],"%") then Number.From([value]) else [value]
Then change this new column to Text data type. In Text data type, it can remain percentages and integers in the same column. If you change it to other data types (e.g. Number), values in a column will be converted into the same format.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
I am still getting a % in the column when I apply the formula.
If I change it to a whole number, then 100% shows up as 1, and so does 80% (rounding up). So I added then (Number.From([grade]) * 100), but still get 1 for each.
Here is my complete formula:
if [myId] = 77 or [myId] = 80 and Text.Contains([myNum],"%") then (Number.From([myNum]) * 100) else [myNum])
Can you show some sample data and expected result in table format? Or show a screenshot of the current table in Power Query Editor without sensitive data? Without seeing the data it's difficult to tell where the problem is.
Best Regards,
Jing
