Forum Discussion
Expression.SyntaxError: Token RightParen expected.
= Table.AddColumn(#"Added Conditional Column", "Custom.1", each if([Document Status Description]="Validation Complete","VALIDATION",IF(AND([Responsible Party]="CE_INV_TEAM",OR([Process Type]="PO Cond...
The code is mixing DAX and power query code. It won't work.
--
My general advice for the logic is to build things up gradually with an if.. then.. else. Get a small section working then add further conditions.
Thanks for your reply
Got the solution
