Forum Discussion
S - Curve
Dear all, good night
Please is it possoble to create dax measure weighted average accumulated by month in power bi by the cost base line using data from Ms project
Hello Geoiane,.
I have reproduced your scenario in Power BI Desktop using sample data aligned with your shared table structure. After transforming your dataset into a normalized format (with columns Measure, Month, and Value), the cumulative and comparative trends for each measure (like PREV. CRON LB, CRON REAL, and CRON. TEND.) were calculated correctly and visualized as expected.
I was able to achieve the expected output as per your requirement.
For your reference, I’m attaching the .pbix file containing the working solution and visuals that replicate your dataset behavior accurately.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Thanks,
Ganesh Singamshetty.Yes, it’s absolutely possible to create an S-curve (weighted average accumulated by month) in Power BI using data from MS Project.
Here’s a simple breakdown of how to do it:
1. Prepare your data
From MS Project, make sure you have these columns:
Task Name
Month (or Date)
Cost Baseline (Planned Cost)
Actual Cost (or Progress %)
2. Create a Weighted Average measure
If you want to calculate weighted average progress based on cost baseline:
Weighted Avg Progress = DIVIDE( SUMX('ProjectData', 'ProjectData'[Progress%] * 'ProjectData'[BaselineCost]), SUM('ProjectData'[BaselineCost]) )3. Create an Accumulated (Cumulative) Measure
To plot the S-Curve over time:
Cumulative Weighted Avg = CALCULATE( [Weighted Avg Progress], FILTER( ALLSELECTED('ProjectData'[Month]), 'ProjectData'[Month] <= MAX('ProjectData'[Month]) ) )4. Visualize it
Put Month on the X-axis.
Add Cumulative Weighted Avg on the Y-axis.
Use a Line Chart to form the S-curve.
15 Replies
Hi,
Share some data to work with and show the expected result in a simple Table format. Share data in a format that can be pasted in an MS Excel file.
Hi, Mr. thanks for replay. Is it possível to share in MDB Access? Because, it's an export of Ms project
In blue, Base line data, in red Real, in green tendence
Hi,
I cannot understand anything from the image. Share the download link of the Excel file with your formulas written there. I will understand those Excel formulas and convert those into DAX measures.
find out the link to download the spreedshet
Cannot understand anything in there. Someone who does will help you.
Hi Geoiane ,
To assist you further, could you please provide sample data that clearly illustrates the issue you're experiencing?- Include a small dataset that fully captures the issue (preferably in table format or as a downloadable file, not just a screenshot).
- Avoid including any sensitive or unrelated information.
- Also share the expected outcome based on the sample data you provide.
Need help preparing or uploading sample data? You can refer to this helpful guide:
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityThis will help us reproduce your scenario accurately and provide a precise solution.
Best regards,
Ganesh Singamshetty.In blue base line, in red real, in green forcast
Hi Geoiane,
To provide a solution tailored to your situation, we need to thoroughly review your data and scenario details. Please share a sample workable Excel file (not images) with dummy data that closely resembles your case, along with the expected output and any other relevant information. This will help us better understand and resolve your issue.
Thank you.
Hello Geoiane,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hello Geoiane,
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you. Yes, it’s absolutely possible to create an S-curve (weighted average accumulated by month) in Power BI using data from MS Project.
Here’s a simple breakdown of how to do it:
1. Prepare your data
From MS Project, make sure you have these columns:
Task Name
Month (or Date)
Cost Baseline (Planned Cost)
Actual Cost (or Progress %)
2. Create a Weighted Average measure
If you want to calculate weighted average progress based on cost baseline:
Weighted Avg Progress = DIVIDE( SUMX('ProjectData', 'ProjectData'[Progress%] * 'ProjectData'[BaselineCost]), SUM('ProjectData'[BaselineCost]) )3. Create an Accumulated (Cumulative) Measure
To plot the S-Curve over time:
Cumulative Weighted Avg = CALCULATE( [Weighted Avg Progress], FILTER( ALLSELECTED('ProjectData'[Month]), 'ProjectData'[Month] <= MAX('ProjectData'[Month]) ) )4. Visualize it
Put Month on the X-axis.
Add Cumulative Weighted Avg on the Y-axis.
Use a Line Chart to form the S-curve.
