Forum Discussion

Otaki's avatar
Otaki
Frequent Visitor
4 years ago

Price recursive calculation

Hi, I have the following issue: I have the current price and I have to calculate the final and the future prices based on  previous ones with this formula: I've tried  this: PriceEndTST_а =...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Otaki Perhaps:

Final price column =
  VAR __Year = [Year]
  VAR __PreviousYear = __Year - 1
  VAR __PYFinalPrice = MAXX(FILTER('Facts',[Year]=__PreviousYear),[Final price])
RETURN
  __PYFinalPrice + __PYFinalPrice * [Increase Percent] - [Decrease const]
  • Otaki's avatar
    Otaki
    Frequent Visitor
    4 years ago

    This was actually my first idea however it doesn't work from the 3rd row on, as there are no values