Creating a simple if statement to classify rows based on the values in ...
As such, I clicked Custom Column under Add Column in the Power Query Editor and inserted the following. = if Text.StartsWith (Number.ToText ( [Column5]),"6") then "B/S" else "I/S") That is trying to say, insert B/S for values in the new column if the first digit is 6, and if not, put “I/S”. There is an error message “Token Eof expected.”