Forum Discussion

kobkabnaja's avatar
kobkabnaja
Icon for Helper II rankHelper II
2 years ago
Solved

Join 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. ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

divyed's avatar
divyed
Icon for Super User rankSuper User
2 years ago

Hello kobkabnaja

 

This can be achieved through creating a virtual relationship at run time. I would suggest using TREATAS function to create virtual relationship between tables with different granularities. I hope this will help.

 

Cheers