Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
= 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 Condition Review(PO)",[Process Type]="PO Conditions Review(DWN)")),"PO CONDITION",IF(AND([Responsible Party]="CE_INV_TEAM",OR([Process Type]<>"PO Condition Review(PO)",[Process Type]<>"PO Conditions Review(DWN)",[Process Type]<>" ")), "VIM EXCEPTION",""))))
Getting Expression.SyntaxError: Token RightParen expected.
Excel formula working fine are
=IF(J2="Validation Complete","VALIDATION",IF(AND(R2="CE_INV_TEAM",OR(P2="PO Condition Review(PO)",P2="PO Conditions Review(DWN)")),"PO CONDITION",IF(AND(R2="CE_INV_TEAM",OR(P2<>"PO Condition Review(PO)",P2<>"PO Conditions Review(DWN)",P2<>" ")), "VIM EXCEPTION","")))
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