.

rainchong7401  Good Morning,

#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [UNIT] = "PALLET" then 0 else if [UNIT] = "KG" then "0" else 1, type any)

**Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!