Forum Discussion

Foxxon28's avatar
Foxxon28
Helper I
3 years ago

Create Forecast Measure

Dear reader,   I want to create a Power BI line chart that shows a running total of the total Budget, per month, and fill in the rest of the year with an average of the forecast.   My data struct...
Need Help
Show and Tell
Tips and Tricks
  • Foxxon28's avatar
    Foxxon28
    Helper I
    3 years ago

    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.