+2
Hi there! On the topic of the FORECAST_LINEAR formula: Is there a way to select certain values for the ranking dimension? For example, if:
FORECAST_LINEAR('Sales','Month’)Best answer by Benoit
View original
+12
Hi,
I don’t think it’s possible to choose certain months in the ranking dimension because it has to be the dimension itself.
However, given that Sales uses Month, maybe you can try to filter your source data like this:
FORECAST_LINEAR('Sales’[filter: Month.boolean],Month )
Hope this helps.
Please let us know how it looks.
Best,
+2
Thanks, yes filtering on the source data worked. Thanks Benoit.
+6
Hello
Benoit beat me by a few minutes with the exact same idea I had, but since I did try to do a comprehensive demo, I believe it is still worth it sharing it.
I have made two calculations, one where the Linear Regression is manually calculated and the other using FORECAST_LINEAR.
I have then done it in a such a way that the when the Exclude boolean changes, the “Valid Period” is recalculated to ignore the period excluded - find table below.
As you can see above, y = mx + b does not include the excluded periods in the calculation of the linear regression, while FORECAST_LINEAR is just excluding them from the base data set.
As you can see in the picture below, ultimately the result is the same.
I hope the above makes sense and complements
+2
Thanks for the demo Bruno, this looks like a great use case :)
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
