Forum Discussion
Identify missing employees from two tables
Hi All,
I have two tables. One with period no and a list of all active employees (employee id). I then have another table with period No and all empoyees who have submitted timesheets. I have created a variance chart by XVIZ and I want to show a table of all employees who have not submitted timesheets i.e the variance between the two. I was hoping when I clicked the variance component of the chart, this would identify what I am lookoing for but it just shows all employees who did submit timesheets in that period.
Any ideas on other visuals I could use or how I can achieve this?
Thanks You!
2 Replies
- amitchandakSuper User
pparke , check this file look at the measure and measure 2
https://www.dropbox.com/s/3wr697b3m57zufo/ExceptOther%20Tabl.pbix?dl=0
- v-eachen-msftCommunity Support
Hi pparke ,
Do your second table have employee id? You could use EXCEPT() function to get this employees.
Or you could show more details here with files and screenshots.