Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
thanks
Solved! Go to Solution.
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 , 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
thanks for your reply
i tried this
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
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
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
12 | |
11 | |
8 | |
6 |