Forum Discussion

vinaydavid's avatar
vinaydavid
Icon for Helper III rankHelper III
6 years ago

Except function with a filter - unlogged employees

Hi All,   Want to achieve the below result from the 2 unrelated tables.   Table 1 - Logged employees list with logdate Table 2 - Complete list of employees (without logdate) Everyday I get a li...
Need Help
nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

vinaydavid ,

 

You can use the EditQuery Merge option.

Table2 merge with Table1 using employeeID. (All from first matching from second). Then expand the merged table and filter the blank dates. 

 

Another Option, create a calculated column in Table2, using lookupvalue() you can search the value in Table1. If it is return blank() that means that the employee is missing in Table1.



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

  • vinaydavid's avatar
    vinaydavid
    Icon for Helper III rankHelper III
    6 years ago

    nandukrishnavs ,

    Thanks for your reply.

    I can't go with the 1st option, as the report gets filtered using a slicer.

    So I need to filter the userlist based on a logdate, and then compare with Table 2.

     

    For 2nd option, as I am a beginner in dax, not sure if we can use lookupvalue and filter or some other function to restrict for a selected date.