Summarized table question

[Anonymous]

Hello everyone,

Please help me with this. 

I have two tables Order and Product. The relationship is many to many based on product id. 

Now I want to build a new table, containing the product id, and order date, supplier. 

I tried to use summarizecolumns function but it doesn't reflect any relationship I set up. 

The order date is from the order table, others are from the product table. 

Thank you

[amitchandak]

@Anonymous , Try not to join them directly, use bridge tables

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

https://www.seerinteractive.com/blog/join-many-many-power-bi/

[Anonymous]

Hi amitchandak

Do you mean after using the bridge table, summarizecolumns should be able to detect my relationship and I'm able to pull all the data?

Thank you