Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DATEADD and min function DAX

hi community  i was hoping someone can help me figure out below    what i want to do is , for each week_start period, i want to bring the minimum of date_update add 13 weeks to it (182 days) and b...
DATEADD and min function DAX
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， Anonymous 

    Please try formula as below:

    Measure =
VAR mindate =
    CALCULATE ( MIN ( 'myData'[DATE_UPDATE] ), ALL ( 'myData' ) )
RETURN
    CALCULATE (
        SUM ( 'myData'[FORECAST_VALUE] ),
        FILTER ( 'myData', 'myData'[DATE_UPDATE] = min_date )
    )

    Best Regards,
    Community Support Team _ Eason

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    thanks for your reply 

    i tried this 

     

    forecastvalue = var min_date = min(myData[DATE_UPDATE])+182
    var forecastv = CALCULATE(SUM(myData[FORECAST_VALUE]) ,myData[DATE_UPDATE] = min_date)
    Return forecastv
     
    and it does not return any values 
     

     

    what i really want to return from all the values for week_start 8/8/2022 is value of 11572 which happend on date_update 16/05/2022

     

     

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi， Anonymous 

      Please try formula as below:

      Measure =
VAR mindate =
    CALCULATE ( MIN ( 'myData'[DATE_UPDATE] ), ALL ( 'myData' ) )
RETURN
    CALCULATE (
        SUM ( 'myData'[FORECAST_VALUE] ),
        FILTER ( 'myData', 'myData'[DATE_UPDATE] = min_date )
    )

      Best Regards,
      Community Support Team _ Eason