Forum Discussion

a_guest1005's avatar
a_guest1005
Frequent Visitor
3 years ago
Solved

Struggling to Model Data

I've got a s/s of data which is a list of risks that have 1 or more actions (1:m). However each risk can then be assigned to one or more goals and vice versa a goal can have many risks attached  - (M:N)
I've broken this using a bridge table with a combined key.
When I try link it back to the actions, this then becomes a M:N relationship.

I need to be able to drill grom goal, throguh risk into action.

I have no measurable facts as such so all teh tables are Dimensions but valuses such as target date, etc can change making them SCD.

Should I just be creating one big table with all the columns and then hvaing redundant data within it  (effectively mulitipl rows for a single action, linking it back to the risk and then the relevant goals). Effectively, a risk could have 4 actions and be attached to 3 goals, effectively creating 12 rows for the risk/goal/ action combination (if i've done my maths right)

Any ideas would be appreciated 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi a_guest1005 

    You can combine risks and tasks to one table, then set it as a data table, then create a unique key in new table and action table to create relationship. And 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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi a_guest1005 

    You can combine risks and tasks to one table, then set it as a data table, then create a unique key in new table and action table to create relationship. And 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.