Merging 2 data sets based on Dates and supplier name

[Anonymous]

Hi

I am trying to merge 2 sets of data to provide 1 holistic view of the supplier.

I have:

1. One table / dataset which provides supplier spend
2. A second table / dataset which provides the supplier performance.

My aim is to get both of these datasets in sync so i can slice by Date or Supplier and both datasets update.

At present i have only been able to get them either slice by either Date or Supplier as it would cause a circular reference 

[MFelix · Accepted solution]

Hi @Anonymous ,

You are making several many to many connections and with both way filtering, this is causing you model to have the connections already made from each side.

Believe that the best way is to have a Supplier dimension table with unique values that make the connections to the suppliers data with one to many relationship.

[Anonymous]

hi @MFelix 

Its not 100% what i was trying to acheive, however i was a bit naive and it has worked. Thank you.

I will now go away and find the next problem, hopefully you are around to get be back on track.

Thanks again

Lee