Forum Discussion

yosemite's avatar
yosemite
Icon for Helper III rankHelper III
6 years ago
Solved

LOOKUPVALUE - Need Help

Hello,   I need to perform a look up of Table1[Column1] in Table 2[Column1] and return values that do not exist in Table1[Column1].   Appreciate any help.   Thank you.
  • camargos88's avatar
    camargos88
    6 years ago

    Hi yosemite ,

     

    Take a look at this file: Download PBIX 

     

    Basically I grouped the values per week and joined with a left anti and filtered nulls.

     

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

  • camargos88's avatar
    camargos88
    6 years ago

    yosemite ,

     

    Check this new file: Download PBIX 

     

    Take a look at the week_missing table on Power Query.

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

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

camargos88  Although I didn't have to filter out 'null' values, it worked on this simple dataset; see link below. 

 

My dataset has thousands of employees, and they are not being filtered out. I followed all the steps. 😣

 

Yosemite_v1.pbix 

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

yosemite ,

 

Check this new file: Download PBIX 

 

Take a look at the week_missing table on Power Query.

 

Did I answer your question? Mark my post as a solution!
Ricardo

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

    Thank you very much! camargos88 

     

    You've been extremely helpful.