Forum Discussion
hongho2
3 years agoFrequent Visitor
Custom column
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 ...
- 3 years ago
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"
Greg_Deckler
3 years agoCommunity Champion
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"