Hi, I am attempting to calculate some future forecast trends but I am having trouble summing totals for specific periods of time. I essentially need to be able to sum the next 3, 6 and 12 month forecast based off the earliest date in my forecast file (LATEST S&OP ACTUAL). My attempt is blow but it is not working and just calculates the whole file rather than the specified number of days (in the below statement 93 days). Any ideas on this one?
Rolling 6 month Forecast Qty (units) = CALCULATE([YTG Forecast],DATESBETWEEN(Dates[Date],MIN(‘Latest_S&OP Actual’[Date Value])+93,MIN(‘Latest_S&OP Actual’[Date Value])))