Forum Discussion
S-Curve Forecast Histogram and Line
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
- AllanBerces2 years agoPost Prodigy
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