Forum Discussion
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
- Anonymous3 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
- AnonymousNot 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.