Forum Discussion

jansaldi's avatar
jansaldi
Regular Visitor
2 years ago

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

AKPacific Northwest
ALSoutheast
ARSoutheast
AZSouth Central
CAWest
COSouth Central
CTNortheast
DCMid-Atlantic
DENortheast
FLSoutheast

 

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

  • Anonymous's avatar
    Anonymous
    Not 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 Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.