Commas and connections

[ThomasWeppler]

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?

[Anonymous · Accepted solution]

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