Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
2 years ago

S-Curve Forecast Histogram and Line

Hi Good day,
Im stablishing S-curve in PBI, but im stuck on scenario on how to distribute the remaining hrs equal to my daily plan plus increase in hour or additional scope. and any additional hour or increase in hour will plot after the last date of my daily plan same on the remaining hrs. Thank you very much in advance.


From this

to this

 

 

Thank you

Allan

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi AllanBerces ,

    Do you want to distribute the value into daily basis? If yes, you can refer the following links:

    Solved: Splitting Monthly Targets Into Daily Ones - Microsoft Fabric Community

    Daily Target =
DIVIDE (
    Table[Spend],
    SWITCH ( TRUE (), Table[Month] = "January", 31, Table[Month] = "February", 28 , ...)
)

    Solved: Split monthly values to daily values - Microsoft Fabric Community

    How to split budgets to lower granularity with DAX  

    BudgetSplit =
VAR FirstQTRDate =
    STARTOFQUARTER ( Dim_date[Date] )
VAR LastQTRDate =
    ENDOFQUARTER ( Dim_date[Date] )
VAR BudgetDates =
    DATESBETWEEN ( Dim_date[Date], FirstQTRDate, LastQTRDate )
VAR BudgetToDivide =
    CALCULATE ( [TotalBudget], Dim_date[Date] IN BudgetDates )
VAR NumOfDays =
    COUNTROWS ( BudgetDates )
VAR DailyAmount =
    DIVIDE ( BudgetToDivide, NumOfDays )
RETURN
    SUMX ( VALUES ( Dim_date[Date] ), DailyAmount )

    If the above ones can't help you get the expected result, please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with special examples and screenshots. Later I will check if there is any workaround to achieve your requirement. You can refer the following link to share the required info:

    How to provide sample data in the Power BI Forum

     

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

    • AllanBerces's avatar
      AllanBerces
      Post Prodigy
      2 years ago

      Hi,

      Thank you for your reply. pls refer below other detailed. hope to help me this .

      and the number generated should not exceed on the max date (3/16/2024) everyday will change the number base from the current remaning (Measure)

       

      Thank you

      Allan

  • AllanBerces's avatar
    AllanBerces
    Post Prodigy
    2 years ago

    Hi,

    Good day.

    Can anyone please im having trouble with my S-Curve. I have a daily earned, Plan and Forecast reflected on my S-Curve. What I need is.

       1. The Forecast bar will dis-appered once I have daily Earned and the new Forecast bar will calculate base from     current remaning from today to max date of my plan.

    2. Any increased mnhrs on my Daily plan will add-up to my daily plan from today to max date of may plan.

    3. connected Cumulative line of Daily earned + Forecast.

     

    Thank you in advance and really much appreciated.

     

     

     

       2.