Forum Discussion
Create forecast table
Best regards to the attentive community. I am looking for an alternative to establish a Forecast that consists simply of increasing the figures in the table by a percentage factor. For this I req...
Syndicate_Admin , if you need rows you can do crossjoin or generate with year
example
generate([Table]. generateseries(2020,2024,1) )
you can addcolumns and add some logic
addcolumns(generate([Table]. generateseries(2020,2024,1) ),
"New value" , Switch(true(),
[year] =[value], [Amount],
[year] < [value], [Amount],[value], [Amount] * (1+([Value] - [Year])/100)
)
here value us coming because of generateseries