Forum Discussion
Solved
Count open items each day, 2 date columns
Hi team, I have a date table, and a data table, the three relevant columns from the data table are: ID Date Issued Compliance Date 1 1/01/2020 10/01/2020 2 5/01/2020 14/01/2020...
Hickling , You can try a measure like one used in HR Analytics
CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))
You can refer this blog
Hickling , You can try a measure like one used in HR Analytics
CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=max('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))
You can refer this blog
This is perfect, thank you!
