DAX measure to calculate forecast

[Alex_nor]

Hi all!

I need help with a DAX measure to obtain "Actual_NewForecast" as this table from excel shows:

My model has the following tables: DimDate, FactActual, FactFeed and FactArrivals.

The DAX measure should make the same calculation as the excel formula does in Actual_New Forecast column for each row.

Any sugestion?

Thank you

[nareshr89 · Accepted solution]

Try this  * Table name is FCT

FCST =

var data = SELECTEDVALUE(FCT[Date])

var arrivals = CALCULATE(SUM(FCT[Arrivals]),ALLCROSSFILTERED(FCT),FCT[Date]<=data && FCT[Date] <> 202401)

var feed = CALCULATE(SUM(FCT[Feed]),ALLCROSSFILTERED(FCT),FCT[Date]<=data && FCT[Date] <> 202401)

var result = IF(data=202401,500,

                    500-arrivals-feed)

Return result