Forum Discussion
Create Relationship on Compound Key
So, can someone tell me why I can't join tables on more than one key? This seems like one of the most basic query functions yet it can't be done. I see people saying 'create a calculated column', b...
You can do it in M. If you choose in your transformation in Home/ "Merge Queries", you can highlight the 2 columns to match in both sides of the join.