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
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.
kobkabnajaHelper II
Helper IIThanks Kedar_Pande ! Although I have not achieved what I want, your solution is super helpful!