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

Anonymousthank you for reply.

I created the linked table according to your explanation above.

I create a table with OfferName of the calculated table and the List Price of Pricelist. If i choose "don't summarize" i get the error message "can't display the visual".

What do i have to do to create a visual with the correct list price for each OfferName( Product) ?

 

Hope you can help me, Anonymous

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi EMGI,

 

Have you drag the product id(from link table) to table visual? Current power bi seems not support to analysis mapping with multi-columns, you need to drag summary column to help power bi correct recognize records mapping.

 

Regards,

Xiaoxin Sheng

  • EMGI's avatar
    EMGI
    Frequent Visitor
    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.