I thought that creating a relationship between two tables in Power Pivot would allow me to select a column from Table A and a column from Table B and then see the corresponding items related per row, like a SQL join. I don't understand the logic as to why it doesn't work that way but it certainly doesn't. So what I figured I would do is join all of these tables together into one query and then put it into Power Pivot. It works well but surely there is a better way because this query is massive and annoying to maintain.
Also, can anybody help me understand the logic of the table relationships? Are relationships just to have the ability to aggregate data?
Bookmarks