Forum Discussion
Need help with Custom column syntax in power query editor
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
thanks AlB , that worked like a charm !
2 Replies
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
thanks AlB , that worked like a charm !
