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...
Thanks for replying to my post. I had two issues; case sensitivity and a typo on a field name ...
Regards