Forum Discussion
Helper IIEstablishing a Relationship Between Analytical Views for Load Tasks and Product Backlog Items
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.
Super Userkrishanw , 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-8e3eccb41bda
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw