Forum Discussion

EMGI's avatar
EMGI
Frequent Visitor
8 years ago
Solved

Many to Many Relationship

Hey everybody,   i need your help. Let me explain my problem: I have 2 tables which will be updated/imported every month with a new csv-File.   In the table "calculated table" i have different, ...
Need Help
  • EMGI's avatar
    EMGI
    8 years ago

    Hi everbody,

     

    got the solution. First problem was to choose the wrong "offerID"-column to get a relationship.

    I created a unique ID in the Pricelist concatenate with OfferID + Month(ValidFromDate) + Year(ValidFromDate).

     

    Thanks for replies and help.

EMGI's avatar
EMGI
Frequent Visitor
8 years ago

My problem is how to create a link table with the values of the other two tables?

 

Which columns i need in the link table to get going on with the calculation?

 

I think the table has to be dynamically updated every time a new OfferID and a new price is inserted, or am i wrong?

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI EMGI,

 

You can try to create calculated table with 'Union' and 'DISTINCT' functions to merge columns and get unique id.

Sample formula:

Link Table =
DISTINCT (
    UNION ( VALUES ( calculated[OFFER ID] ), VALUES ( Pricelist[OFFER ID] ) )
)

 

Regards,

Xiaoxin Sheng