topic Re: DATEADD and min function DAX in DAX Commands and Tips

DATEADD and min function DAX

Anonymous — Mon, 06 Jun 2022 05:32:39 GMT

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 bring the value for that.

example for week start 8/8/2022 , i want to bring value of date_update 16/05/2022 which is 11572. and so on ....

so everyweek that i have new row of data , it goes back to fine the new min date and add 182 days to it and give me the value

i created totalf = SUM(MYDATA[FORECAST_VALUE])

so i thought i can use dateadd function and bring the minimum date_updated and add 182 days to it

mindate = min(dateadd(MYDATA[DATE_UPDATE] , 182, DAY))

thanks

Re: DATEADD and min function DAX

amitchandak — Mon, 06 Jun 2022 09:15:26 GMT

Anonymous , You can simply do it like

min(MYDATA[DATE_UPDATE]) + 182

Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827

Re: DATEADD and min function DAX

Anonymous — Mon, 06 Jun 2022 09:33:29 GMT

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

Re: DATEADD and min function DAX

v-easonf-msft — Fri, 10 Jun 2022 09:23:00 GMT

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