get list of employee names based on 2 dates in a table

[Lahari]

Hi Everyone,

I have scenario where i have 2 different date columns by name interviewed date and joining date in an employee table. 

Now i want to get list of employee based on interviewed date and joining date. 

In google i have searched many videos and blogs but i found measures showing Sum(tables[sales]) for ship date and order date and measures are as follows

sales for order date = Sum(tables[sales])

sales for ship date = calcaulate([sales for order date],userelationship(calendardate[date],tables[date])

Here i am getting total sales this is ok. But in my scenario i want list of employee names instead of total sales so anyone tell me what i need to change in the measure in order to get the list of employee name details.

please help me in writing this measure. Thanks in advance. 

[grazitti_sapna]

Hi @Lahari 
You can try using this:-

Employee List =
VAR InterviewedDate = SELECTEDVALUE(EmployeeTable[InterviewedDate])
VAR JoiningDate = SELECTEDVALUE(EmployeeTable[JoiningDate])
RETURN
CONCATENATEX(
FILTER(
EmployeeTable,
EmployeeTable[InterviewedDate] = InterviewedDate &&
EmployeeTable[JoiningDate] = JoiningDate
),
EmployeeTable[EmployeeName],
", "
)

Hope this will help you.
Thank you

[Nithinr]

@Lahari  Is your question is you will have two slicers interview date and joining date and you need to get candidates based on date selected in slicer? If yes you can create two independent tables and slicers edit interactions to use specific slicer to specific table.

[Lahari]

Hi @Nithinr 

Yes i have 2 slicers but i dont want 2 independent tables but i need it in single table like

Interviewdated date(9/28/2023)	Joineddate(9/30/2023)
A	A
B
C	C

or with solution of yours if i create 2 independent tables then after that i need to merge those 2 independent tables by full join and need it as single table. Is that possible to get this output.