I am trying to calculate a forecast of the metric tons that will move in the organization, from the forum I found some code that I have used in my model, but I encounter a problem
I am making the forecast based on the days of the month, which for this example (April) would apply 30 days.
But not all business units (Segments) operate every day of the month, case the COPE business unit in the data I have given me an average of 15 days
So, when I forecast this business unit it does so on current average * 30 giving a very high figure when it should be for 15 days
I tried to calculate the average of days and replace it with the days of the month, but since I am filtering or eliminating the month of April, I cannot make it work.
I am concerned that when I want to go to a deeper level, I have no idea how to calculate the average
for example, if you had the levels of:
attached the pbix.
thanks for your help
Forecast OSI’s v2.pbix (2.8 MB)