Forum Discussion
Forecasting Future Numbers - table
Circling back on this, I'm trying to put into a table the financial forecast for the next 5 years, based on this year's growth rate. I have precalculated everything and have this DAX: Measure 2 = I...
thanks jgeddes, here is what I put in and here is the error I recieved:
Measure 2 = IF(HASONEVALUE('Calendar Table' [YEAR DATE]) && VALUES(('Calendar Table'[YEAR DATE])) > VALUE(YEAR(TODAY())),
CALCULATE([Sales], FILTER('Sales Report','Sales Report'[Sale Date]=YEAR(TODAY())))
* POWER((1+[Current Growth%]), 5))
Error: Caclulation error in mesaure 'Extrap Tabl'[Measure 3]: A table of multiple values was supplied where a single value was expected.