Forum Discussion
Helper IIEstablishing a Relationship Between Analytical Views for Load Tasks and Product Backlog Items
I have two analytical views: one for load tasks and the other for product backlog. Now, I want to create a relationship between these two to load only related product backlog items. What is the common key to add a relationship between these two tables?
Hi krishanw
amitchandakGood share!
Create a relationship between two tables, usually based on the same fields in the two tables.
If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you.
You can also go to the model view interface to create relationships by dragging fields or editing.
You can view the link below for more details:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
krishanw , I think you need common dimensions like Area Path, Assign to, Client and Date. And join both tables with those
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Hi krishanw
amitchandakGood share!
Create a relationship between two tables, usually based on the same fields in the two tables.
If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you.
You can also go to the model view interface to create relationships by dragging fields or editing.
You can view the link below for more details:
Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
