Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We set the budget for each project at the start of the work. We record actual expenditure monthly. We do not however, show the budget as a monthly amount against which we compare the actual expenditure.
I would like to create a column in the relevant table that has the project budget split into monthly amounts, based on the number of months planned for the project. This is so that I can create a line chart that compares cumulative actual expenditure against budget.
Example data can be found at: https://www.dropbox.com/s/sxukjfske24rmi8/Example43.pbix?dl=0
Thanks
Steve
Hi,
Even though you have shared the PBI file, i cannot understand your data/question. Please share/explain your business question/data more elaborately.
At its simplest, I want to:
I can then use this data to compare the monthly budget against the actual expenditure.
This is not a very accurate representation of the real situation. To make it accurate, I would need to only include the budget for projects when they are "Active". So the budget figure would be adjusted as projects start and finish.
Is this clearer. I have a good picture of what I want to do in my head. Explaining it in writing is a bit more difficult.
Thanks
Steve
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |