After watching a lot of the videos, i’d really like to embrace Sam’s recommendation on how to layout the tables, avoiding bidirectional and having waterfall layout. I have some data Staff table (Dim) 1 row per Staff member Team table (Dim) 1 row per Team member Dates table (Dim) 1 row per …

In addition to the suggestions already made by @Heather here’s another thought [image] StuartFlint: Staff to Team Mapping table - contains which Team a staff member was in on a given day. I’m assuming this is a fact table I would consider that to be a slowly changing dimension , type 2 is com…

Avoiding Mulit to Multi relationship

Power BI Data Model

Heather October 14, 2021, 9:56am 2

some good techniques have been discussed in this forum post - please see if one of these solutions can help.

If not, then a mock up of your model might be needed to better understand your specific use-case.