Forum Discussion

chlimaye's avatar
chlimaye
Regular Visitor
1 year ago
Solved

Data Model relation to get expected solution

Hi There,   Please find below screen shot of data model.   We are developing one table viz and requirement is    we have one column which is derived in DCV table and used a global filter....
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi chlimaye 

    There is a many-to-many relationship in your data model. It is recommended that you use a bridge table to transform this relationship. You can refer to the following link.

    Many-to-many relationship guidance - Power BI | Microsoft Learn

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi chlimaye,

Thank you for reaching out in Microsoft Community Forum.

Thank you Anonymous  for the helpful response.

As suggested by v-xinruzhu-msft, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.