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
gaurav-lakhotia
Helper I
Helper IHi kobkabnaja ,
- You have to create a relationship between these two tables by creating a composite key, May be using Year(Date), Sub-category & Department.
- To avoid duplication, you can calculate the daily budget by dividing the yearly budget by number of days in the year (as p[er the business logic).
- Relationship using a composite key can help here. Ofcourse, DAX would help alot here.
Let me know need further help.
|
kobkabnajaThanks gaurav-lakhotia! This is a bit off from my case.