Forum Discussion
Create Forecast Measure
Foxxon28 , refer if this approach can help
PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
Thanks for the suggestion!
However I do not think this will work, as I am working with a variable "Actual Budget", that gets updated every month and need to "fill in the blanks, till December". The method used above does a "fill in the blanks" for the whole year, whereas I need to have a running total of the "known data" (From my example jan - apr) and fill may - dec using a measure, based on a known Forecast Budget (135).
What my expected outcome would be to show a running total from jan - apr (going to 53)
and have may - dec be filled with a liniar line, straight to 135.