Custom column with IF and AND statement

[Anonymous]

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?

[mahoneypat · Accepted solution]

This should work

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

Regards,

Pat

[wdx223_Daniel]

clike Add Column ---> Custom Column, and input this formula

= [BoatIncludeExcludeItemId] = 68 and [Included]

[Icey · Accepted solution]

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 · Accepted solution]

This should work

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

Regards,

Pat