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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Kudoed Authors