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