Forum Discussion

bnadir55's avatar
bnadir55
Regular Visitor
7 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.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
7 months ago

Hi bnadir55.,

Thank you lbendlin Kedar_Pande, for your insights.

I reproduced the scenario using your sample data and got the expected output. Please find the screenshot and PBIX file attached for reference. Hope this helps.

 

 

Thank you.

bnadir55's avatar
bnadir55
Regular Visitor
7 months ago

Thx! But it seems I am dealing with another challenge where my weight is in another table: ActivityWeights , which I have connected using a relationship properly and code not recognize :

 

  • bnadir55's avatar
    bnadir55
    Regular Visitor
    7 months ago

    BTW I have managed to change DAX to this :

     

     

    But how can we get it 100% , and why its not smooth ?

     

     

     

     

     

     

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      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.

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      7 months ago

      Hi bnadir55,

      Checking in to see if your issue has been resolved. let us know if you still need any assistance.

       

      Thank you.