Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Eliminate Many 2 Many Relationship

Hi,   I am facing the issue while building many 2 many relationship, so far it works well when I want to display sales vs actual as per month, location, but when it comes down to customer codes, I ...
Need Help
Show and Tell
Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Hi amitchandak thanks for the response, basically I only need to create realtionship between customer key from both the tables, the problem is I dont have some keys in my plan query, but they exisist in actual, what will be the best way to eliminate them in such a way so that there is no issue when buiulding the relationship.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anmolgan ,

 

We can try to create a Dimension tables to connect two tables by using following code:

 

Dim Table =
DISTINCT (
    UNION ( DISTINCT ( 'TableA'[Column] ), DISTINCT ( 'TableB'[Column] ) )
)

 

If you want to delete some rows to achieve a 1:M relationship, could you please share the logic of deleting rows or use some mockup sample data to explain it?

 

Please do not share files if it contain any confidential information or real data.


Best regards,