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 

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.