topic DAX measure to calculate forecast in DAX Commands and Tips

DAX measure to calculate forecast

Alex_nor — Mon, 19 Feb 2024 08:03:45 GMT

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 — Mon, 19 Feb 2024 11:23:50 GMT

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