Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
4 years ago
Solved

Table over a table

Hi,   I have a following relationship where the customer table is related to ssummary (one to many) tables then summary table have a relation to the sale table (many to many)   and so when i do t...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Can't you create a bridge table?

abc_777's avatar
abc_777
Solution Specialist
4 years ago

i have company code in the sale table and ssummary table and 

 

customer_id  in the customer table and Customer_code in ssummary table

 

would be able to help me how i create bridge using distinct

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

You can create the bridge table using the equivalent to:

Customer Table =
DISTINCT (
    UNION (
        VALUES ( 'Customer Table'[Customer ID] ),
        VALUES ( 'Summary table'[Customer ID] )
    )
)
  • abc_777's avatar
    abc_777
    Solution Specialist
    4 years ago

    Hi paul

    thanks for your reply.

     

    I have many-to-many relation to ssummary and sales table that has 

    customer_id  in the customer table and Customer_code in ssummary table

     

    how i make bridge table in this case 

     

    moreover, i am querying from customer tale to sales but ssummary table is in middle of customer and sales table