Relationship in Power query

[S_Rehman]

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?

[mussaenda]

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.