Hi, I am looking for some help in working out a forecast model based on the following information. It seems a complicated way of working it but it's how I have been asked to build it in.
For each remaining day of the current month, I have to use the average for the corresponding day(s) in the previous month and then add on the current month data to get the forecast.
For example if there was a Friday left in the July, I have to get the average of the Fridays in June, added to the days so far in the month to calculate the forecast for the month end. Similarly if there is a Thursday and Friday left in July, I get the average of June Thursdays and the average of June Fridays, this then gives me my forecast for Thursday and Friday in July, added to the MTD figures to give me the month end forecast. It doesnt matter if there is 1day or 29 days remaining, it would be the same format, previous month days average = remaining month days to then give a forecast of month end average.
Hope you are able to follow this, it's easy to put together in an excel spreadsheet, but unsure where to start in PowerBI.
Thanks for any help
