Forecast Sales with Fibonacci Table

[CuriousGuy001]

Hi Everyone,

I was using a simple moving average for a forecast sales and notice it doesn't work cause I got a recursive problem for the same period. I noticed that Fibonacci seems to be one of the best solution to come up for my Sales Forecast report. So far, I tried to do one calculation that I have search in one of the posts in the Fabric Community and was wondering if there is something wrong with my DAX,

This is what I was trying to use moving average,

Fibonacci Table,

[v-fenling-msft]

Hi, @CuriousGuy001 

I am glad to help you.   

Unfortunately, because you did not give us the error message and your dataset, we are unable to directly resolve your issue at this time. You can click see details to see the specific error message.

Please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file.

We will do our best to help you solve the problems you are experiencing.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CuriousGuy001]

Unfortunately, those data is related to work, and I can't share it. Sorry!