Forum Discussion
Helper IIILOOKUPVALUE - Need Help
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
Community Champion
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 🙂
yosemiteHello 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!
camargos88- yosemite
This didn't work. Thanks for trying.
Since my goal is to get a list of employees that do not exist in Table1 by Week, I would like my merged table to return the following:
Week Employee Name Week 2 Employee2 Week 2 Employee4 Week 3 Employee2 Week 3 Employee3 Week 3 Employee4 Week 3 Employee5