Establishing a Relationship Between Analytical Views for Load Tasks and Product Backlog Items

[krishanw]

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?

[Anonymous · Accepted solution]

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.

[amitchandak]

@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-soluti...

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw