Forum Discussion
Solved
Calculated Column of Row Count Using Date Comparisons
I have a table of service requests, each with an open and close date. I also have a date table with measures that count opened and closed on each day. Now i'd like a measure or a calculated column to...
amitchandak
Super User
Super User
That's exactly what I needed and couldn't find. Some form of this:
Current Employees = 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))
Thank you very much for your help!