Forum Discussion

2 Replies

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

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

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago
    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