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.
M code for a DAX expression
Hi everyone, I need to transform this DAX expression in M: Week= YEAR(Calendar[Date]+26-WEEKNUM(Calendar[Date],21)) & "-" & IF(WEEKNUM(Calendar[Date],21)>=10, WEEKNUM(Calendar[Date],21), "0" & WEEKNUM(Calendar[Date],21)) which calculates the week of the year followed by the year for each date of my calendar, according to the European system: Can you help me? Many thanks!
