Forum Discussion

bnadir55's avatar
bnadir55
Regular Visitor
8 months ago
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%...
Curve
DAX
Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    7 months ago

    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.

lbendlin's avatar
lbendlin
Super User
8 months ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523