Forum Discussion

Karthick_BI's avatar
Karthick_BI
New Member
3 years ago

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.

No RepliesBe the first to reply