Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
KuntalSingh
Helper V
Helper V

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 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","")))

2 REPLIES 2
HotChilli
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.