Making an active relationship between two tables where no relationship exists

[Alex_Hasan]

In this two tables, there is no relationship (Only many to many relatioship can be formed). So, I want to make 1 to many relationship where the factsales will also contain customerkey (Many side)  How to write a dax forthis? 

[v-mengzhu-msft]

Hi @Alex_Hasan,

You should first create relationship between two tables, through the same field:

And then you can make 1 to many relationship based on “Customer Key.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Alex_Hasan]

Hi, those two ETLloadIDs are many to many relationship.  what should I do? 

[amitchandak]

@Alex_Hasan , In the customer table, the customer key should be unique and should not have a blank value. then you should be able to create a 1-M join

[Alex_Hasan]

Yes, customer key column is unique and does not have a blank value. But how to create a customer key column in factsales table?