Forum Discussion
andybamber
Helper III
Helper IIIHelp on How to Create a Measure Based on Start & End Date
Hello! Hoping someone could help me with some advice on how to build a measure I have a table of users, with start and/or end timestamps. The table is an access history for the users. Som...
andybamberHelper III
Helper IIIHi amitchandak
So, this measure almost does what I need, except it does not provide a distinct count of user...
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))
Do you know how i could incorporate this?
Thanks