Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Long if statement in Power Query is not showing a syntax error but the result is 100% errors - not sure why

        if [Legal Type 2]="Corp" and [Valid TIN]="Valid" and [Guarantor Subtype]="Unlimited" then "Priority 1" else if [Legal Type 2]="Corp" and [Valid TIN]="Invalid" and [Guarantor Subtype]="U...
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi,

 

What do the error messages say?

Click on the whitespace in a cell that has the green "Error" in it and screenshot/copy the error.

 

Pete