Forum Discussion
Helper IIMaking an active relationship between two tables where no relationship exists
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?
4 Replies
- amitchandak
Super User
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_HasanYes, customer key column is unique and does not have a blank value. But how to create a customer key column in factsales table?
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?
