Same day Previous week DAX
Hi All, I have a table containing daily incident request raised by team members with columns - start date of INC, end date of INC, INC number, status, comments. Here, i need to build a report table showing date wise incident count and previous week count for each date. Eg: if today is 17/04/2023, then it should display count of incidents on that date along with previous week count. i.e. count of 10/04/2023 in same row. I have tried multiple dax formulas but nothing working. Either it returns day count or blank values. Please find attached image for reference.
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 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
