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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nglenn1
Regular Visitor

Forecast Future Value with DAX

To The Community,

 

I've turned over every rock I can find trying to replicate in DAX, a report we have in excel that forecasts future months of data based on the last 6 months of actuals. I need to forecast the monthly values shown below in red based off of the last completed months value plus a growth expectation and then, add again to that value, the fixed growth expectation and so on for the next, future, 6 months. My data structure is simple... Date table that has future dates/months, fact table that has up to the current month. 


It's not a cumulative or running total or annualization, but somewhere in between.


I'm embarassed to admit the time I've spent on this researching and trying technique after technique.. Any help would be GREATLY appreciated. 

2023-02-24_21-01-20.png

2023-02-24_11-29-43.png

4 REPLIES 4
Vilmar
Resolver I
Resolver I

Deve ter uma maneira mais fácil, mas veja se o anexo te ajuda.

Não entendi muito bem a média para dar o valor 50.

 

PBIX aqui 

 

Captura de tela 2023-04-28 211608.jpg

 

 

Alicetemitope
Frequent Visitor

Hi, please did you get any help? facing similar issue but on a daily granularity. thanks

nglenn1
Regular Visitor

@TomMartens , Thanks for reaching out! Below is a OneDrive link to the sample data I put together for the screenshot above in an Excel file. Let me know if that doesn't work.
SampleData.xlsx

TomMartens
Super User
Super User

Hey @nglenn1 ,

 

please provide a pbix that contains sample data but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method, share the xlsx as well.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.