Forum Discussion
Counts rows between dates
Hi, I have a function created in Excel: (=COUNTIFS(INCIDENTS[sys_created_on], "<="&[@Date], INCIDENTS[NEW resolved], ">="&[@Date], INCIDENTS[sys_created_on], "<"&[@[Date-10]], INCIDENTS[sys_created_...
Date is week_start (which is the column that appears in Incidents and Calendar, because it's simply the start of each week). I created a Calendar table so that I wouldn't have to compare it row by row, but when I used this table to some extent, I didn't get a satisfactory result either.
I would like the measure to calculate exactly like a formula in Excel - searching for data that meet the condition