Forecast with filters from multiple tables

[Anonymous]

I am trying to make a forecast based on past values.
This is my original measure:

Calculate(Sum('Updated Indata from Section Managers'[Value]);'Updated Indata from Section Managers'[Project]="Project" )

Now I want to add another measure as a forecast based on this measure the year before. However I cannot get the combination Project/Date to work:

VAR Forecast =

Calculate(Sum('Updated Indata from Section Managers'[Value]);'Updated Indata from Section Managers'[Project]="Project" ;DATEADD(DimDate[Date]; -1;YEAR)*(1+0.1))

RETURN If(YEAR(MAX('Dimdate'[Date]))=2022;Forecast)

 Grareful for help getting my head around this 🙂

[PowerUserR · Accepted solution]

Hi,
Just looking at this quickly it seems like you are using both "," and ";" which can cause errors.
For the last if statement, you will need a value if false as well.

[Anonymous]

The datamodel was the problem, but your tips were correct! 🙂 Thanks!

[Anonymous]

Thanks for the tips.

I cannot get the VAR Forecast to work (with corrected ";", ",")