Forum Discussion
Anonymous
8 years agoNot applicable
return string value for relative date based on slicer, not aggregate
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. ...
Ashish_Mathur
Super User
8 years agoHi,
Share some data and show the expected result.
Anonymous
8 years agoNot applicable
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
- Ashish_Mathur8 years ago
Super User
Hi,
I am sorry but i just do not understand. Why should the answer be 1 and 2 in the third table?
- v-yuta-msft8 years ago
Community Support
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