Need help with Custom column syntax in power query editor

[Anonymous]

I have written one DAX formula to calculate new field as below 

BackUp Reviewer Name = IF(AND('reviewers'[ID or Group Name <>'reviewers'[PrimaryID],'reviewers'[Steward]=0),'reviewers'[Reviewer Name])

Now i am trying to create same field by using custom column in query editor like  below  ,(I know it's wrong)

IF [ID or Group Name] <> [PrimaryID] [Steward]=0 then [Reviewer Name]

need your assistance to write this in custom column syntax 

[AlB]

Hi @Anonymous 

Try this (watch the lower-case, M is case-sensitive)

   if [ID or Group Name] <> [PrimaryID]  and [Steward]=0 then [Reviewer Name] else null

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous · Accepted solution]

thanks @AlB , that worked like a charm !