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

Question

I have 3 tables&nbsp;one table has team names2nd table has individual names and their date of leaving the company3rd is the date table.&nbsp;2nd and 3rd tables are linked through termination date.&nbsp;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.&nbsp;&nbsp;

ashish_mathur · Answer

Hi,&nbsp;Share some data and show the expected result.

anonymous · Answer

Hi, Here is what I am looking for:&nbsp;Table 1TEAM NAME&nbsp; TEAM IDTeam 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234Team 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4567&nbsp;Table 2EMPLOYEE NAME&nbsp; &nbsp; &nbsp;END DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Team ID&nbsp;John Smith&nbsp;Scott Mann&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;February 1, 2018&nbsp; &nbsp; 1234Lisa Jackson&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; March 28, 2018&nbsp; &nbsp; &nbsp; &nbsp;4567&nbsp;Result I'm looking for:TableTEAM NAME&nbsp; &nbsp; &nbsp; # EMPLOYEESTeam 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1Team 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;Slicer-&gt;select Month &amp; Year&nbsp;

ashish_mathur · Answer

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

v-yuta-msft · Answer

Hi&nbsp;Jaeeunc,&nbsp;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?&nbsp;Regards,Jimmy Tao

Forum Discussion

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

4 Replies

Related content

Slicers on Aggregated Measures

Relative Date and Custom Date slicers conflicting

Relative Date Slicer

Date relative and between range slicers

numeric slicer for aggregated Y axis