Forum Discussion
Join between tables
Hi Anonymous ,
In fact, you not need to join fields to another table.
After you finished to create relationships, you can direct to use table fields to create chart/visuals.(power bi will analyze summarize these fields based on current relationship and group fields)
Create and manage relationships in Power BI Desktop
Work with aggregates (sum, average, and so on) in the Power BI service
BTW, after you build relationship between tables, you can add a calculated column with related function to simply invoke related field from related table.
Regards,
Xiaoxin Sheng
Do you mean that the join and the relationship is not the same or I misunderstood?
Anonymous
Hi,
JOIN and RELATIONSHIP work on similar fundamentals, i.e. there should be one common field between the two tables. However, the major difference between them is that by using JOIN you are compiling all the data into one table and then creating your reports/data model; however, using RELATIONSHIPS you can achieve the same results by linking the two tables.In your case, you can first create a relationship between stock and order table and then proceed with creating visuals or tables.
And I do not think that there is any difference between joining with a primary key and joining with a normal field. As long as you can create a unique combination for the query to map the required field, the result should not be any different.
Thanks,
Vivek
- If we make a link between the tables with a normal field not unique then we will have values that are repeated !!
In your opinion how to create a relationship? I did not understand how to link 2 tables, I know that with the primary key it's all- Between Stock and Order table, I am hoping that there should be column for ItemID or ProductID.
Even for Join, you would need something common between the two tables
