Calculated Column of Row Count Using Date Comparisons

[bperry1]

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 display the backlog based on opened date prior and close date later or null. It seems simple and I've tried a few methods but the DAX is just not coming to me.

[amitchandak · Accepted solution]

@bperry1 , See if this can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[bperry1]

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!