Forum Discussion

joep78's avatar
joep78
Icon for Helper III rankHelper III
5 years ago
Solved

Forecasting on existing numbers

Hi all,

 

I'm looking for a solution that will help me with a forecast overview. The following(test) data is available (based on contract data):

Yearamount
2020150
2021125
2022122
2023121
2024110
202575
202645
2027

20

 

What I want to archive is the following view:

 

YearamountForecast
2020150768
2021125618
2022122493
2023121371
2024110250
202575140
20264565
20272020

 

Whereby the Forecast is a SUM of amount of the current year and all future amounts included. 

 

The data is demo data, the real data set is ofcourse bigger but if I get a good suggestion I think I can make this work in the orginal environment as well.

 

Thanks in advance for a reply!

 

Regards,

 

Joep

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    joep78 , Create a measure like this and try

    calculate(sum(Table[amount]), filter(allselected(Table), Table[Year]>=max(Table[Year])))

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    joep78 , Create a measure like this and try

    calculate(sum(Table[amount]), filter(allselected(Table), Table[Year]>=max(Table[Year])))

    • joep78's avatar
      joep78
      Icon for Helper III rankHelper III
      5 years ago

      Hi Amit,

       

      Thanks for your very quick response, this was just what I needed so again, thank you!