Kindly Explain if we have to use bridge table? How should we decide which columns(Data) should we make dimension? Like in our case we decided that we should make dimensions like ( date,fruits,country) Thanks
Good question. I go through when you’d want to use a bridge table in the video. Generally use a bridge table when there is a non unique column that you want to join. I explain it more in the video, if that explanation isn’t clear then certain websites might help
Very good. Thanks. I think of a Bridge table as a master list that allows me to filter either table. I'm just wondering if you could merge 2 bridge tables, one created from Budget and one from Actuals to be 100% certain you catch all unique Fruits in both tables. In other words find a way to include Mango in the Bridge Table. And stacked tables seem a useful tool.
Thanks for the comment! Actually I had a video segment about appending the two bridge tables but the video was too long so I cut it from the final version but that is such a great suggestion!
Hi I’m not sure how you could join them if there is no common column, it would require the app to guess which ones match. You need to find a way to have a common column even if it means creating one manually or via power query
I used the same workaround as Bridge table that you have mentioned. But when I pull in the fields of all three tables into 1 visual, it is giving me an error "Can't determine relationship between the fields". Can you please let me know how to handle this?
Thanks for the question. Unfortunately it’s a different reason every time so it’s hard to answer. I’d recommend posting in a forum where you can add screenshots & even upload the file that way others can help
I mention dates in Power BI, the link is in the video description, but here it is again for you: th-cam.com/video/Dj4IRe0qZPw/w-d-xo.htmlsi=19SbyoMMez5W1Iks
Kindly Explain if we have to use bridge table? How should we decide which columns(Data) should we make dimension? Like in our case we decided that we should make dimensions like ( date,fruits,country)
Thanks
Good question. I go through when you’d want to use a bridge table in the video. Generally use a bridge table when there is a non unique column that you want to join. I explain it more in the video, if that explanation isn’t clear then certain websites might help
Very good. Thanks. I think of a Bridge table as a master list that allows me to filter either table.
I'm just wondering if you could merge 2 bridge tables, one created from Budget and one from Actuals to be 100% certain you catch all unique Fruits in both tables.
In other words find a way to include Mango in the Bridge Table.
And stacked tables seem a useful tool.
Thanks for the comment! Actually I had a video segment about appending the two bridge tables but the video was too long so I cut it from the final version but that is such a great suggestion!
hw to join two tables if they dont have any common column between them ?
Hi I’m not sure how you could join them if there is no common column, it would require the app to guess which ones match. You need to find a way to have a common column even if it means creating one manually or via power query
Cool
Thanks!
I used the same workaround as Bridge table that you have mentioned. But when I pull in the fields of all three tables into 1 visual, it is giving me an error "Can't determine relationship between the fields". Can you please let me know how to handle this?
Thanks for the question. Unfortunately it’s a different reason every time so it’s hard to answer. I’d recommend posting in a forum where you can add screenshots & even upload the file that way others can help
Hello Brother, you have told in video saying that have created another video where is it. please share link
I mention dates in Power BI, the link is in the video description, but here it is again for you: th-cam.com/video/Dj4IRe0qZPw/w-d-xo.htmlsi=19SbyoMMez5W1Iks