topic Re: Custom column with IF and AND statement in Power Query https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1486575#M46366 <P>clike Add Column ---&gt; Custom Column, and input this formula</P><P>=&nbsp;<SPAN>[BoatIncludeExcludeItemId] = 68 and [Included]</SPAN></P> Wed, 11 Nov 2020 07:56:57 GMT wdx223_Daniel 2020-11-11T07:56:57Z Custom column with IF and AND statement https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1482817#M46244 <P>Hi, I have 2 columns that look like this</P><P><img /></P><P>&nbsp;</P><P>Now I want to create a custom column that shows "TRUE" when</P><P>ID=68 and</P><P>Included = TRUE</P><P><BR />How do write this in Power Query?</P><P>&nbsp;</P> Mon, 09 Nov 2020 13:17:01 GMT https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1482817#M46244 Anonymous 2020-11-09T13:17:01Z Re: Custom column with IF and AND statement https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1482826#M46246 <P>This should work</P> <P>&nbsp;</P> <P>= if [BoatIncludeExcludeId] = 68 and [InFulllEquipmentPackage] = true then true else false</P> <P>&nbsp;</P> <P>Regards,</P> <P>Pat</P> Mon, 09 Nov 2020 13:20:56 GMT https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1482826#M46246 mahoneypat 2020-11-09T13:20:56Z Re: Custom column with IF and AND statement https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1486465#M46364 <P>Hi&nbsp;Anonymous</LI-USER>&nbsp;,</P> <P>&nbsp;</P> <P>You can also create a custom column like so:</P> <LI-CODE lang="markup"> = if [ID] = 68 and [Included] then true else false</LI-CODE> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Icey</P> <P>&nbsp;</P> <P><SPAN>If this post&nbsp;</SPAN><STRONG>helps</STRONG><SPAN>, then please consider&nbsp;</SPAN><EM><STRONG>Accept it as the solution</STRONG></EM><SPAN>&nbsp;to help the other members find it more quickly.</SPAN></P> <P>&nbsp;</P> Wed, 11 Nov 2020 06:53:15 GMT https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1486465#M46364 Icey 2020-11-11T06:53:15Z Re: Custom column with IF and AND statement https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1486575#M46366 <P>clike Add Column ---&gt; Custom Column, and input this formula</P><P>=&nbsp;<SPAN>[BoatIncludeExcludeItemId] = 68 and [Included]</SPAN></P> Wed, 11 Nov 2020 07:56:57 GMT https://community.fabric.microsoft.com/t5/Power-Query/Custom-column-with-IF-and-AND-statement/m-p/1486575#M46366 wdx223_Daniel 2020-11-11T07:56:57Z