S-Curve Forecast Histogram and Line

[AllanBerces]

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

[AllanBerces]

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. 

[Anonymous]

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]

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