Forum Discussion
Show only active Employees
Hi Agador,
You could achieve this by filtering both on the start and end date. If I understand correctly you are currently only filtering based on the startdate with a between. On top of this you would also want to filter the end date to filter out any employees who have left service by a certain time. Below you will find an example of how to manage this:
From and To Date Slicers in Power BI: Filtering Based on Two Fields - RADACAD
best regards,
Tim
Solution SageHi Agador,
You could achieve this by filtering both on the start and end date. If I understand correctly you are currently only filtering based on the startdate with a between. On top of this you would also want to filter the end date to filter out any employees who have left service by a certain time. Below you will find an example of how to manage this:
From and To Date Slicers in Power BI: Filtering Based on Two Fields - RADACAD
best regards,
Tim
Thanks Tim, that seems to have done the trick. Much appreciated.