Forum Discussion
Karthick_BI
3 years agoNew Member
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