Status change of employee upon dynamic date selection using slicer

[NidhiBhusari]

Given is the Emp Name, Start Date and EndDate of project during this period the employee was considered as BILLABLE. If any other Date is selected from slicer which is not in StartDate and EndDate then Status must show as NONBILLABLE.

Employee Name	FromDate	ToDate
A	07-07-2021	07-12-2021
B	08-04-2021	08-10-2021
C	09-03-2021	09-11-2021
D	10-07-2021	10-12-2022
E	11-01-2020	11-12-2021
F	12-08-2021	12-01-2022
G	13-02-2021	13-06-2021
H	14-05-2021	14-01-2022

[NidhiBhusari]

@amitchandak thanks for quick response and exact solution...It's working.

[amitchandak · Accepted solution]

@NidhiBhusari , Create a measure as current employees give in this blog.

Then plot table date(from date table) and employee

a new measure you need is

example, few more filters to be added

if(isblank([current employee]) , "Non billable", "Billable")

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