New Column based off of first 4 of different column value

[Anonymous]

I am having an issue with creating a formula that works. 

I have a column where they values either start with"3213" or "3215" and I need a formula that gives me an output of "A" in the new column for 3213 or an output of "B" in the new column for 3215.

TIA for the help. 

[Anonymous · Accepted solution]

You can do:

= Table.AddColumns(PriorStepOrTableName, {{"Indicator", each if Text.StartsWith([Item #], "3213") then "A" else "B", type text}})

--Nate

[Anonymous]

Awesome, this worked. Thank you for the help!

[Anonymous]

Result would look something like this. 

Thanks again.