Financial Forecasting

[jkulyk]

Hi 🙂 

I would like to build a simple financial forecasting model based on "price" and "quantity" for the rest of 2024.

The "actuals"  coming in to my model each month from SQL database. 

Now, I have a matrix with the actual data "price","quantity" and "Sales" for each month and want to calculate the sales for the rest of the year based on the parameters price&quantity. (need to change the parameters on the front end to see how the sales will develop)

Does anyone has an advice for building this in a clear structured way? (or tips for visuals)

Best Regrads 

Johannes

[MFelix]

Hi @jkulyk ,

Have you tried using the What-If parameter?

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

You can create a table with a range of values and then use them on a dax calculation on top of your actuals.

[jkulyk]

yes, i tried the what if parameters. But its not really working..

Do you mean to build a table like this?

[MFelix]

Hi @jkulyk,

The option is to create those what if parameters and the have a calculated measure to pick up the values.

Can you please give an example of what you want to achieve and the setup of your model. that will help to give you a more appropiate answer.

[jkulyk]

hi:) the problem is that i dont want to calc the what if parameters on top of my actuals. I have my actuals till today and then i want fixed values from the what if parameters:

As you see its not working because i cant link the parameters to a specific date range...

[MFelix]

Hi @jkulyk ,

How do you want to have those values incremented do you want to select the last Actuals and then the 99.000 every month, or how is that split done?

[jkulyk]

yes exactly. Till July the actuals and then the forecasting. Or better till today() 

[MFelix]

Hi @jkulyk 

Try the following code:

Total Sales + Forecast = var temptable =	SUMMARIZE(
		'calendar',
		'calendar'[monht],
		'calendar'[year],
		"Value", IF(
			MAX('calendar'[Date]) <= EOMONTH(
				TODAY(),
				0
			),
			SUM(Salers[Value]), [PRice Value] * [Quantity Value]
		)
	)

 Return
 Sumx(temptable, [Value])

[jkulyk]