Forum Discussion

DuncanMelville's avatar
DuncanMelville
Regular Visitor
7 years ago
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, and am unsure of the way to proceed.

In the Query Editor, I created two custom date columns to add 1 and 2 years to the actual transaction date.

In the Data View, I created two measures to calculate the year1 and year2 forecasts using the annual inflation from a separate table.

I now want to show the year 1 and year 2 calculated forecast in one visualisation and on one timeline. I don't want to have two separate visualisations. 

Should I create a calculated forecast table and push the year1 and year2 calculations into it? I would then be able to have one visualisation for the data.

I appreciate any advise on this.

Thanks, Duncan

  • Thanks, Stachu. I found another way round this, but will need to come back to it in a while

2 Replies

    • DuncanMelville's avatar
      DuncanMelville
      Regular Visitor

      Thanks, Stachu. I found another way round this, but will need to come back to it in a while