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.

ZinouBakhouche's avatar
ZinouBakhouche
New Member
8 years ago

I have another issue related to Many to Many relationship, we were moving from one forecasting tool (F1) to another one (F2) the two files have:

- Same Report line key" (high Level) but different "Account Key", the issue is that Report lines are at higher level means one report line can have multiple Account Key in both systems.

- Another issue is that one Account Key in (F1) can be linked to multiple lines in (F2) via reportline and vis versa (one Account Key in (F2) can be linked two multiple lines in (F1) via reportline). means that reportline cannot be used as a unique value to create a relationship nor account levels as they have many to many relationship.

- I created a bridge but with Reportline only, where I'm relating both tools together tight to report line, but this will not help me to check the F1 and F2 variances at account level (I got the same number everywhere.

is there anyDAX formula which could help me solve this issue?
thanks in advance.