Forum Discussion
Merging tables/creating relationships
Hi All, I'm hoping someone may be able to help me here...I have one table that has mutiple rows for each date which looks something like this: Date Channel Goal 1 01/...
Hi Anonymous
Yes Chris, You can use Query Editor, Merge Queries and Left outer join to combine your tables. Please see the screenshot.
Merge, Left Outer Join and Expand, Select Visits
Thanks a lot for your prompt response Bhavesh! Your answer helped me in my particular case.
However, my general concern remains. It looks like you cannot manage left join effectively with the relationships. For example, if you have two tables Sales and SelectedOutlets, you cannot build relationship between them so that the result displays sales for those outlets which are in the SelectedOutlets table and others which exist only in the Sales. Right?
However, my general concern remains. It looks like you cannot manage left join effectively with the relationships. For example, if you have two tables Sales and SelectedOutlets, you cannot build relationship between them so that the result displays sales for those outlets which are in the SelectedOutlets table and others which exist only in the Sales. Right?
Hi Anonymous
The relationship view (One to Many Relationship Type) is equivalent to Left Outer Join in SQL World.
If you are looking to understand the relationships and cross filter view in Power BI, Please go through the below video resource.
https://www.youtube.com/watch?v=8ybsChtuZoY
and Microsoft Documentation:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships