.

[rainchong7401]

.

[Ahmedx]

Column = VAR _Current =[Unit]

  RETURN

  IF(_Current="PAIL"|| _Current="TIN",1,0)
--
OR

Column 2 = VAR _Current =[Unit]
RETURN
IF(_Current in {"PAIL","TIN"},1,0)

download the file

https://dropmefiles.com/2Q2ZA

[Mahesh0016]

@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 !!