Forum Discussion
DAX repeating values
Hello, I am creating a forecast by averaging the previous 6 months data. I can get those values no problem. However, I want to repeat next month's forecast for the upcoming months. For example, ...
Benedict21 , Try a measure like using Incidents Forecast measure
calculate(lastnonblankvalues(Date[Date], [Incidents Forecast]), filter(all(Date), Date[Date] <= max(date[Date]) )