Forum Discussion
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.
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!
Ricardoyosemite ,
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
18 Replies
I would recommend you to use the merge option (right outer) in Edit Query instead of DAX.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-queries
https://radacad.com/choose-the-right-merge-join-type-in-power-bi
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Hello nandukrishnavs - Thanks so much! I was able to obtain a list of what doesn't exist in Table1 by using Right Anti.
What I'm trying to do is to get a list of Employee Name that does not exist in Table1 by 'Week'. Table2 contains distinct employee and does not have a 'Week' column.
TABLE1
Week Employee Name Week 1 Employee1 Week 1 Employee2 Week 1 Employee3 Week 1 Employee4 Week 1 Employee5 Week 2 Employee 1 Week 2 Employee 3 Week 2 Employee 5 Week 3 Employee 1 Table 2
Employee Name Employee1 Employee2 Employee3 Employee4 Employee5 Any help is appreciated!
