Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom column with IF and AND statement

Hi, I have 2 columns that look like this   Now I want to create a custom column that shows "TRUE" when ID=68 and Included = TRUE How do write this in Power Query?  
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    This should work

     

    = if [BoatIncludeExcludeId] = 68 and [InFulllEquipmentPackage] = true then true else false

     

    Regards,

    Pat

  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    You can also create a custom column like so:

     = if [ID] = 68 and [Included] then true else false

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

This should work

 

= if [BoatIncludeExcludeId] = 68 and [InFulllEquipmentPackage] = true then true else false

 

Regards,

Pat