Forum Discussion
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...
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