cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vandestra
New Member

relationship

Hi Guys,

I have a problem with relationships. I try to combine surveys from different sources about our 40 schools. Some surveys have questions about the school, other surveys have questions about the principals.  We would like to compare average scores. 

Some principals are connected with one school over many years. Other principals change schools or have more than one school to lead. Some schools are lead by more than one principle. 

I would like to create a data model in which I can easily calculate scores for both schools and principals. 

Would this be possible ? See attachment of what we want to do.

 

probleem data directies scholen.png

 

1 REPLY 1
sreenathv
Super User
Super User

In data modelling, this is a classic case of "many-to-many" relationships. It is possible to do the modelling in these scenarios and it is quite elaborate to explain. So rather than me explaining it, there is a well written article on how to handle these scenarios using a "bridge table" by sqlbi.com.  

 

sreenathv_0-1638787113791.png

Refer to this link https://www.sqlbi.com/articles/many-to-many-relationships-in-power-bi-and-excel-2016/ 

 

Please go through this and if you have any trouble understanding the concept, feel free to reply. Someone will help you.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors