Forum Discussion
Solved
Merging Queries with OR
Hello, I am attempting to merge to queries together but I need to do so not simply with a TableA.Key1 = TableB.Key1 but instead with TableA.key1 = TableB.Key1 OR TableB.Key2 I have found a wa...
In Power Query you would need to do two merges, one with each. Then keep the valid data you want with an if/then/else statement. You can do a conditional merge based on records as shown here but I think trying to do that with tables would be painfully slow.
if the key1 and key2 in Table B is unique, you can try LOOKUPVALUE
In Power Query?
I definitely would not do this kind of shaping in the data model using DAX. If it is a few hundred or thousand rows it might be ok, but would not scale well. Power Query or further upstream is where this belongs for sustainable performance.