Custom column

[hongho2]

Hi,

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.

[Greg_Deckler · Accepted solution]

@hongho2 You seem to be writing DAX in Power Query (M). The proper syntax for M (and yes, case matters) is:

if [Purchase Office] =  [New Purchase Office] then "T" else "F"