Forum Discussion
kobkabnaja
Helper II
Helper IIJoin and model the data with different granularities
Hi Community, I'm new to Power BI and would appreciate any guidance on handling data with different granularities. I've done some research but still feel unsure about the best way to approach this. ...
Hi kobkabnaja
Your question has soved at another post, so you can consider to close this post, and you can offer solution in this post so that more user can refer to.
Best Regards!
Yolo Zhu
kobkabnajaHelper II
Helper IIKedar_Pande Thanks for your quick response! I have a quick follow-up question. When linking the datasets, should I join them column by column using a many-to-many relationship, or should I combine the relevant columns into a unique key and use a one-to-many relationship?
I’d appreciate any further thoughts or comments you may have.
Kedar_Pande
Super User
Super Userit's generally more efficient to avoid many-to-many relationships unless necessary.
Use a one-to-many relationship with a unique key.
- kobkabnaja
Thanks Kedar_Pande ! Although I have not achieved what I want, your solution is super helpful!