dateadd in existing measure

[teflonreis]

Dear everyone

I would like to ask for your help.

I use a dax measure to visualise a bar chart. I want to shift the bar of March 5 month ahead of August and so forth using the dateadd function. 

Your help is greatly greatly appreciated.

My current measure is this:

forecast measure =
VAR forecast =
CALCULATE (
SUM ( Execution_forecast_tbl[weighted_effort_FOM] ),
FILTER (
Execution_forecast_tbl,
IF (
OR (
OR (
Execution_forecast_tbl[forecast type] = "MDB forecast",
Execution_forecast_tbl[forecast type] = "SF STR"
),
Execution_forecast_tbl[forecast type] = "SF TR"
),
Execution_forecast_tbl[timescale] > EOMONTH ( TODAY (), 0 )
)
)
)
RETURN
forecast

[FreemanZ]

hi  @teflonreis,

just add the DATEADD part like:

forecast measure =

VAR forecast =

CALCULATE (

    SUM ( Execution_forecast_tbl[weighted_effort_FOM] ),

    FILTER (

        Execution_forecast_tbl,

        IF (

            OR (

                OR (

                    Execution_forecast_tbl[forecast type] = "MDB forecast",

                    Execution_forecast_tbl[forecast type] = "SF STR"

                ),

                Execution_forecast_tbl[forecast type] = "SF TR"

            ),

            Execution_forecast_tbl[timescale] > EOMONTH ( TODAY (), 0 )

        )

    ),

    DATEADD(DateTable, 5, MONTH)

)

RETURN

forecast

or?

[teflonreis]

heeey

Thanks for the response.

What could I use in the first line of Dateadd for Datetable. I have a calender table. Also have a time column in the Execution_forecast_tbl[timescale].

Tried both so far with no success 😞