Many to Many Relationships

[illusionek]

Hello

I've got two tables that I would like to join based on Supplier ID and Week Number. It would be dead easy to do it in Access but I struggle with PowerPivot. I was playing with Bridge Tables but it doesnt seem to be working as I get the total value from the second table without proper split by Supplier ID. Whats the best way to approach it?

 

[Matt Allington]

Well, Power BI is not the same as access. There is a lot to learn, but I share a lot of info on my blog. I suggest you start here

The Optimal Shape for Power BI Data

It is common for self taught Power Pivot users to get the shape of their data all wrong. This article describes the optimal way to do it.

exceleratorbi.com.au

Relationships in Power BI and Power Pivot

Level: Beginners Power Pivot is a database that has been designed from the ground up to be optimised for reporting and analysis in Power BI, Power Pivot for Excel and SSAS Tabular. The technology is essentially the same across all of these products so I will generically refer to Power [...]Read...

exceleratorbi.com.au