Forum Discussion
How do you make a conditional column that references columns in another query in Power Query?
Basically, I have a column in one query called State_Province__c that contains the two-letter state abbreviations. I have another table in a different query that looks like this:
State Event Region
| AK | Pacific Northwest |
| AL | Southeast |
| AR | Southeast |
| AZ | South Central |
| CA | West |
| CO | South Central |
| CT | Northeast |
| DC | Mid-Atlantic |
| DE | Northeast |
| FL | Southeast |
I want to make a conditional column in the first query where if the State_Province__c column equals the state column in the second query then the output is the event region column of the second query else null.
Any help would be appreciated. Thank you!
1 Reply
- AnonymousNot applicable
Hi jansaldi ,
It doesn't seem to work, but this is a requirement you can implement by creating a relationship between the two tables, which feels good.
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.