Forum Discussion

teflonreis's avatar
teflonreis
Frequent Visitor
3 years ago

dateadd in existing measure

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

 

DATEADD

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      teflonreis
      Frequent Visitor
      3 years ago

      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 😞