Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
CuriousGuy001
Helper I
Helper I

Forecast Sales with Fibonacci Table

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,

CuriousGuy001_1-1721832953126.png

This is what I was trying to use moving average,

CuriousGuy001_2-1721833061343.pngCuriousGuy001_3-1721833083187.png

Fibonacci Table,

CuriousGuy001_0-1721833302530.png

 

 

2 REPLIES 2
v-fenling-msft
Community Support
Community Support

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_0-1721918653009.png

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.