Forum Discussion

S_Rehman's avatar
S_Rehman
New Member
2 years ago

Relationship in Power query

Hello Experts,

I am trying to use an intermediary unique table (ORD) to avoid many-to-many relationships and pull numbers from both tables but still getting messages of missing relationships. What am I missing here?

 

Need Help

1 Reply

  • mussaenda's avatar
    mussaenda
    Community Champion
    2 years ago

    Hi S_Rehman ,

     

    you will excounter your issue if you use the data of DGM table to the data of OPS

    If you will analyse your relationship, ORD has a relationship to DGM but not the other eay around.

    Same scenario with OPS.

     

    This is not advisable but try to have a both relationship instead of single.

    Or have dim tables for all the common data between DGM and OPS and create measures for the values you need.