Forum Discussion
new table with value from different table
Tridiv It is possible to make relationship between two fact tables (in your case budget and actuals) on different grain levels. All you need to do is to join them to conformed dimensions like Time and department in your case.
The dimension tables have one record for each of your business key so you can make one to many relationship between your fact table and dimension e.g.
Actual - Department - Budget
Many - One - Many
Using this model you can do all of your analysis on department level using Budget and actuals.
I suggest to read about dimensional modelling which will help you to create data models in Power BI.
Harris
HarrisMalik Silly me, of course this works!! thanks for your help. Your comment along with information in the link below sorted my issue!! :)
Tridiv It is possible to make relationship between two fact tables (in your case budget and actuals) on different grain levels. All you need to do is to join them to conformed dimensions like Time and department in your case.
The dimension tables have one record for each of your business key so you can make one to many relationship between your fact table and dimension e.g.
Actual - Department - Budget
Many - One - Many
Using this model you can do all of your analysis on department level using Budget and actuals.
I suggest to read about dimensional modelling which will help you to create data models in Power BI.
Harris
HarrisMalik Silly me, of course this works!! thanks for your help. Your comment along with information in the link below sorted my issue!! :)