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.
I have 3 tables related to projects.
The first table has the project details (Proj name, proj descrption, location, Total Cost $)
The second table, has details of the various project phases (Proj Name, Phase, Start Date, End Date)
The third table has details of project phases e.g. planning, design, procurement & construction, plus sets the standard expected cost as a percentage of the total buget. E.g planning 8%, design 5% ( Phase, Budget split)
There are numerous projects in the total program of works.
Most projects span 2 or more years, with different phases lasting between 1 and 18 months in duration.
I will display the program of works as a gant chart, but I wish to be able to calculate the total expected program expenditure for any given day, week, month or QTR.
I thought I would be able to calculate the average daily expenditure for each phase of each project (by Total Cost * Budget spit then divide by total duration of phase (days)) and then Sum the values for those projects/phase whose start and end dates either fall within or overlap the period.
I would appreciate any adsistance to develop a measure to achieve this.
Thanks Greg for the guidance. This is my first post.
The following image is of a Gantt Chart related to projects. I wish to be able to calculate the SUM of Daily costs, related to each Project/Phase that falls within the target period (QTR, Month, Day etc) and display results in a table on Matrix below the Gantt.
The following images show my Tables and the relationships.
Calculations within the Phase details Table
1. Duration = [End date]-[Start Date]
2. Total Budget = Related('Project Details'[Cost ($2017M)])
3. Budget Split = Related('Budget splits'[% of Budget])
4. Daily Cost = ([Total Budget]*[Budget Split])/[Duration]
Assistance to in developing an appropriate measure would be appreciated.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |