topic Re: dateadd in existing measure in DAX Commands and Tips

dateadd in existing measure

teflonreis — Thu, 09 Feb 2023 08:20:49 GMT

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

Re: dateadd in existing measure

FreemanZ — Thu, 09 Feb 2023 08:52:34 GMT

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 (

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?

Re: dateadd in existing measure

teflonreis — Thu, 09 Feb 2023 10:11:17 GMT

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 😞