Forum Discussion
Create relationship between with two columns
Dear all! I have diffrent tables with data, format something like ID | MsId | Date | [stat values] Date and MsId is not uniq each other, but unique both. How can I link my tables by two col...
I just come up with the same problem of joining composite keys and looking around for a solution.
Sad to see that the answer is "doing some workarounds"...... :catsad:
Even the old-aged Microsoft Query is doing better on this..... I'd better go for the MS Query...... :smileylol:
Before using MS Query for joining the tables together, really give Power Query a chance. MS Query and PQ are not even from the same Universe, especially when it comes to transformation in later jobs ;)