Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Not in List Daily

Hi,  I have two tables, one static table with a list of names and IDs in departments, and another table that is an export of employees filling out a questionaire daily. I was wondering if there...
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago

    Anonymous  Al is also in the ch station right so should display too?

     

    Use ALLSELECTED() instead of ALL(): 

     

    MissingForm =
    VAR formcomplete = VALUES(FormSubmissions[Employee ID])
    RETURN
    CONCATENATEX(FILTER(ALLSELECTED(Employees), NOT(Employees[ID] IN formcomplete)), Employees[Name], ", ")
Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

You can do an ANTI JOIN in Power Query in Power BI on these two tables and find out the one that have not filled out the questionaires.

 

Check out the details here:

https://www.powerbi-pro.com/en/power-bi-seven-types-of-table-joins/

https://radacad.com/find-mismatch-rows-with-power-query-in-power-bi

 

It will nice to have some sample data to have more clear picture on your issue with some screenshots as well.

 

Thanks,

Pragati