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 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi! Thank you so so much for your help! I recreated the file with test data. I have 5 columns:
Date
Count of Incidents
Count Incidents Sum (measure)
Count Incidents rolling average (measure)
Cumulative Forecast (measure)
I want to repeat the forecasted value for the next month (9 in this case), and not continue the rolling average. So Jan 2023, Feb 2023, Mar 2023, etc., should all equal 9.
Thank you again for your help!