Forum Discussion
Solved
Creating a 24 month rolling forecast using prior 12 months actuals plus annual inflation
I am fairly new to PowerBI and need some direction on the best way to create a 24 month rolling forecast. I want to show the results of the calculated 24 months rolling forecast in one visualisation,...
Thanks, Stachu. I found another way round this, but will need to come back to it in a while
Stachu
Community Champion
Community Championyou don't need the additional columns for the additional years - just additional rows in your calendar table (see how to create one here: https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/)
then you expose your forecast and sales using the measures and you should be able to do so in one visual, as they will all share the time axis
Thanks, Stachu. I found another way round this, but will need to come back to it in a while