Which function should I use to convert text to number in a new column?

[925stuart]

Hi,

Which function should I use to convert text to number in a new column?  I want to convert these:-

Chocolate = 1

Candy = 2

Bottled Water = 3

Beer = 4

Thanks!

[925stuart]

Cool!  That was what I needed to get started!  Found the doc!

[AlienSx · Accepted solution]

Hi, @925stuart I hope you've got the idea. 

let
    Source = #table({"product"}, {{"Chocolate"}, {"Candy"}, {"Bottled Water"}, {"Beer"}}),
    rec = [Chocolate = 1, Candy = 2, Bottled Water = 3, Beer = 4],
    new_column = Table.AddColumn(Source, "new_column", each Record.FieldOrDefault(rec, [product]))
in
    new_column