https://community.fabric.microsoft.com/t5/Developer/Custom-column/m-p/3318843#M43380 <P>Hi,</P><P><SPAN>I am new to Power BI and I need help with the syntax, please. I am trying to add a new custom column, and although there are no errors detected at the bottom, I am seeing an expression error at the top. Please refer to the image below.</SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-07-06 113049.jpg" style="width: 535px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/938291i5CC0C53E1A8F3518/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-07-06 113049.jpg" alt="Screenshot 2023-07-06 113049.jpg" /></span></P> Thu, 06 Jul 2023 16:35:35 GMT hongho2 2023-07-06T16:35:35Z https://community.fabric.microsoft.com/t5/Developer/Custom-column/m-p/3318843#M43380 <P>Hi,</P><P><SPAN>I am new to Power BI and I need help with the syntax, please. I am trying to add a new custom column, and although there are no errors detected at the bottom, I am seeing an expression error at the top. Please refer to the image below.</SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2023-07-06 113049.jpg" style="width: 535px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/938291i5CC0C53E1A8F3518/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-07-06 113049.jpg" alt="Screenshot 2023-07-06 113049.jpg" /></span></P> Thu, 06 Jul 2023 16:35:35 GMT https://community.fabric.microsoft.com/t5/Developer/Custom-column/m-p/3318843#M43380 hongho2 2023-07-06T16:35:35Z https://community.fabric.microsoft.com/t5/Developer/Custom-column/m-p/3318859#M43381 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/573515">@hongho2</a>&nbsp;You seem to be writing DAX in Power Query (M). The proper syntax for M (and yes, case matters) is:</P> <LI-CODE lang="markup">if [Purchase Office] = [New Purchase Office] then "T" else "F"</LI-CODE> Thu, 06 Jul 2023 16:46:26 GMT https://community.fabric.microsoft.com/t5/Developer/Custom-column/m-p/3318859#M43381 Greg_Deckler 2023-07-06T16:46:26Z