Dynamic Actuals with Forecast
Hi, I´ve been struggling with this for approx. two weeks now so hopefully someone here can help me. Problem: I have a table (which is combined by 2 separate tables) FC_GL_Table which is Forecasttable + GL Table(actuals). I´ve tried to simplify the Data table as below. As I´ve tried to show below is that when I select ForecastID = FC2501 I want GL from 2025-01-01 -> 2025-02-28, so basicily < 2025-03-01 and Forecast_part = GL (as shown in the support table) And then take Amount where FC part = FC and Forecast_ID = SelectedValue(ForecastID). A forecast have values for 13 months ahead. TLDR: Need a measure or solution so I can have Actuals + Forecast based on which Forecast_ID I choose. And to support this table I have this map table: I will provide the measure I´ve been playing around with. Forecast_Amount = VAR SelectedFCStartPeriod = LOOKUPVALUE(FC_StartPeriod[FCStartPeriod], FC_StartPeriod[Forecast_ID], SELECTEDVALUE(FC_GL_TABLE[Forecast_ID])) VAR SelectedYear = LOOKUPVALUE(FC_StartPeriod[FCStartYear], FC_StartPeriod[Forecast_ID], SELECTEDVALUE(FC_GL_TABLE[Forecast_ID])) VAR Forecast = CALCULATE( SUM(FC_GL_TABLE[Daily_Amount]), FC_GL_TABLE[Forecast_ID] = SELECTEDVALUE(FC_GL_TABLE[Forecast_ID]), FC_GL_TABLE[FC_Part] <> "GL" ) VAR Actuals = CALCULATE( SUM(FC_GL_TABLE[Daily_Amount]), FC_GL_TABLE[FC_Part] = "GL", FC_GL_TABLE[Date] < SelectedFCStartPeriod, ALLSELECTED(FC_GL_TABLE) ) RETURN Actuals + Forecast And this measure wont show any of the actuals, just the Forecast amount, unfortunately (FCStartPeriod = FCStartDate) Let me know if I need to add additional information. Kind regards, Rasmus
