curve

2 Topics

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% based on task completion. I’m looking to incorporate task duration into the weighting logic. Example: A task with a 10% weight scheduled from January 1–10 should have that 10% spread across those 10 days. If two tasks run in parallel during the same period (10% and 5% weights), then a total of 15% of the overall project weight occurs over the same 10-day window. Tables / Columns Used: ProjectProgressDashboard → Start_Date, Finish_Date, Duration_Days WeightsSheet → weight_percent, Weight DateTable → Date Question: Is this the correct conceptual way to model weighted duration in an S-curve (i.e., distribute task weight across its calendar span), and if so תhow should this be implemented efficiently (formula/modeling approach)? Any guidance or examples would be greatly appreciated. Thanks!
Solved
bnadir55
7 months ago Place DAX Commands and Tips
1.3KViews
2likes
8Comments
DAX Help to For Drawdown
Good Day I am trying to calculate the "Drawdown" row as per the below data table example. As you can see the TOTAL CUMATIVE Formula used gives the Cumulative by Year resulting in a value of $186 I am trying to Acheive the "DrawDown" calculation based on WIN(+) and NO WIN(-) by year Hence starting from $186 (Total Budget) - "NO WIN" + "WIN" So in the below example: =186-[5+0]-[25+0]-[15+0]-[5+16]-[15+10]-[30+0]-[25+15]-[15+10] Hence, i need support to develop the above measure Cumulative Drawdown by Year Thanks! Total_Cumulative_Overall = CALCULATE( [Budget], FILTER( ALLSELECTED('_Calendar'), ISONORAFTER(_Calendar[Date], MAX(_Calendar[Date]),DESC) ) )
Solved
hackfifi
3 years ago Place DAX Commands and Tips
1.6KViews
0likes
3Comments