Forum Discussion
Budgets by Department
Hi, Anonymous
for the most straight forward solution I would rearrange the budget table to this
Department Job Budget A Alpha 100 B
Alpha 200 C Alpha 400 D Alpha 300 E Alpha 0 F Alpha 150 And create a Department dimension/table and a Job dimension/table with relationship to both Budget-table and Amount spent-table.
As Total budget is the sum of the department budgets, there is no need to have a separate entry for that in a table. The same goes for total spent and total remaining. You should handle these 3 values as measures. I made a report, based on the data you have provided: .pbix
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hello,
Based on the sample data you provided, you could try to:
- modify the Budget table in PQ, by selecting the last 4 columns and choosing Unpivot other columns.
- Then once you have a row for each budget, split the newly created Budget column so you get a column with the word "Budget" and then another column with the name of your department
- make sure you have a dimension table for both Job and Department
- link the Line items table and the Budget table with Job and Department
- create the Amount Spent measure and the Budget measure
- create the graph as per your needs
Best regards,
ElenaN