Forum Discussion
Solved
Help Needed – Incorporating Task Duration Into Weighted S-Curve (Power BI / Data Modeling)
Hi everyone, I'm working on building an S-curve visualization where the X-axis represents the project timeline (date from start to end), and the Y-axis represents cumulative progress from 0% to 100%...
Hi bnadir55,
The remaining issue concerns how the task weight is retrieved from the related table and how daily values are summed up. You can try the following DAX, which should help by ensuring the weight is treated as a single value per task and that the cumulative calculation is done properly.
Task Weight := DIVIDE ( CALCULATE ( MAX ( ActivityWeights[Weight] ) ), 100 ) ------------------------------------------------------------------------------------------------- Cumulative Progress % := SUMX ( FILTER ( ALL ( DateTable[Date] ), DateTable[Date] <= MAX ( DateTable[Date] ) ), [Daily Weighted Progress] )Thank you.
ProjectTasks (Start_Date, Finish_Date, Weight)
→ Generate series from Start to Finish (1 row per task-day)
→ DailyWeight = TaskWeight / Duration_Days
S-Curve Cumulative =
SUMX(
FILTER( TaskDays, TaskDays[Date] <= MAX(DateTable[Date]) ),
TaskDays[DailyWeight]
)
Line chart:
X: DateTable[Date]
Y: [S-Curve Cumulative]
If this answer helped, please click 👍 or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande