Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi,
Share some data and show the expected result.
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
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
Hi,
I am sorry but i just do not understand. Why should the answer be 1 and 2 in the third table?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |