Joseph Yeates makes a forecast:
I recently had a requirement for a Power BI report to generate a forecast. The report data model consisted of daily amount information, which was aggregated and summarized in the report for monthly totals.
The data was current year to date, but for the remaining months in the year rather than displaying no data, the users wanted to impute the average for all of the previous months that did have data.
Granted, this doesn’t do anything fancy like factoring in seasonality or periodicity, but it is easy to put together.