Forum Discussion
Impactful IndividualCommas and connections
I have two diffrent tables I want to connect.
A subscription table <Subscription> and an assignent table <Assignment>
Every assingment has a uniq id which can be used to identify it (Pretty normal).
And every subscription has a colom which contains all the assingments that need to completed due to the subscription.
If their are multiple connections it is listed like this:
Is there a way I can connect these two tables with this info or alternatively change the identification data so I can connect the tables?
Hi ThomasWeppler ,
In Query Editor:
Step1: split the assingment column in subscription table.
Step2: select all the splited assingment columns and use unpivot feature.
In Power BI Desktop:
Step3: create a relationship between subscription and assingment by assingment id.
Pbix as attached.
Best Regards,
Jay
1 Reply
Hi ThomasWeppler ,
In Query Editor:
Step1: split the assingment column in subscription table.
Step2: select all the splited assingment columns and use unpivot feature.
In Power BI Desktop:
Step3: create a relationship between subscription and assingment by assingment id.
Pbix as attached.
Best Regards,
Jay