Forum Discussion
Solved
Recursive Function Forecasting
Hi there - I have a list of portfolios that I'd like to forecast through time. I also have a seperate table which outlines the quarter over quarter growth rate. I think the right soluti...
hi there - I want to be able to leverage the portfolio date within the list.accumulate loop. Something like if the maturity date is less than the forecasted date then the forecasted value is 0. This is a much more simple example than what I am really trying to do. Definitely seeing that the Dax solution appears to be way more flexible.
then change this part of the code: List.Select(FT,each _{3}<=y{3} and _{0}=y{0} and x{index of date column}<=y{index of date column}