Forum Discussion
Solved
Linking two columns to the same column in a separate table
Hi All, Apologies if this has already been asked, but I've checked a few posts and though they seem similar to my issue, they're not exactly the same as the problem I'm suffering! I used to h...
One approach would be to split the Assigned To column into rows using Power Query. This approach allows your model to scale without creating additional Assigned To.N columns. Be mindful of any metrics in the Tasks table; they will duplicate for each row created (e.g., Hours Worked) and will need to be properly handled.
DataInsights
Super User
Super User
One approach would be to split the Assigned To column into rows using Power Query. This approach allows your model to scale without creating additional Assigned To.N columns. Be mindful of any metrics in the Tasks table; they will duplicate for each row created (e.g., Hours Worked) and will need to be properly handled.
Okay, I think this sounds like a good idea! I've never tried splitting into rows before & duplicating the other data. I should have a task ID that I can use to make sure the values are distinct, so I'll have a go and let you know how I get along!