Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
Hi, those two ETLloadIDs are many to many relationship. what should I do?
@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
Yes, customer key column is unique and does not have a blank value. But how to create a customer key column in factsales table?