Forum Discussion
Employee Count - based on Slicer Selection
Good Morning, I have an interesting problem to solve - KPI is Count of Active Employees Slicers are Year, Quarter, Month Data has employee id along with employee start date and employee end dat...
Thanks Lucien.
i created a range - min data and max date based on what the user selected in the Year, Qtr, Month slicers.
Then i counted Active employees based on an overlap in the employee start and end date and in the selected range.
It works!