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...
LarsSchreiber
Responsive Resident
Responsive Residenthi joserq,
as aparodi suggested, concatenation of these two columns can be a solution. If you don't need both tables in the data model, you can do that job using Power Query and just import the resulting table into the data model. When you click merge you can click the key columns while holding the control key on you key board. This way you are using more than one column per table when you merge your tables.
Maybe this is helpful to you.
Regards,
Lars