Forum Discussion
LOOKUPVALUE - 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
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!
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 Another alternate approach.
Table1
Week Employee Name Week 1 Employee1 Week 1 Employee2 Week 1 Employee3 Week 1 Employee4 Week 1 Employee5 Week 2 Employee1 Week 2 Employee3 Week 2 Employee5 Week 3 Employee1 Table2
Employee Name Employee1 Employee2 Employee3 Employee4 Employee5 Present = var _count=CALCULATE(COUNT(Table1[Employee Name])) var _result=IF(ISBLANK(_count),0,_count) return _resultCreate a matrix visual.
Now you can export this visual. You will get the below table.
Now you can filter zero.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂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!
Ricardocamargos88 - Thank you so much. I feel like I'm getting closer.
Could you walk me through how you 'Added Custom' (Step 6) and joined with a left anti?
