return string value for relative date based on slicer, not aggregate

[Anonymous]

I have 3 tables 

one table has team names

2nd table has individual names and their date of leaving the company

3rd is the date table.

2nd and 3rd tables are linked through termination date.

I have a slicer using the 3rd table but I need just the people who are still with the company in my visuals.

The slicer will select the month and year I am interested in seeing and I would like to see the number of employees by team name.  

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Anonymous]

Hi, Here is what I am looking for:

Table 1

TEAM NAME  TEAM ID

Team 1           1234

Team 2            4567

Table 2

EMPLOYEE NAME     END DATE              Team ID

John Smith 

Scott Mann               February 1, 2018    1234

Lisa Jackson              March 28, 2018       4567

Result I'm looking for:

Table

TEAM NAME      # EMPLOYEES

Team 1                1

Team 2                 2

Slicer->select Month & Year 

[v-yuta-msft]

Hi Jaeeunc,

What's the relationship between the three tables? Which column is your slicer based on?

Could you clarify more details about your tables and expected result?

Regards,

Jimmy Tao

[Ashish_Mathur]

Hi,

I am sorry but i just do not understand.  Why should the answer be 1 and 2 in the third table?