Forum Discussion
Solved
Add prefix to column based on another column
I'm trying to break this data up into two columns that I can subtract from each other. So for example I'd like to change 1950/ 50 to 1950 - 1950 = 0 The problem is sometimes the number on the ...
HIi left4pie2 , the following can be used in the Face.1.2 column in the transformcolumns function.
Table.TransformColumns(#"Previous Step", [Face.1.2] , each if Text.Length(_) = 2 then "19" & _ else _ )
In the next step, you can convert both text columns to Numbers.
