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
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 |
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 - 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?
yosemite ,
First you group all your rows by week and created a new column with a grouped table column.
Table.Join(
#"Table (2)", "Employee Name",
Table.RenameColumns([Rows],
{"Employee Name", "EmployeeName"}),
"EmployeeName", JoinKind.LeftAnti)Did I answer your question? Mark my post as a solution!
Ricardocamargos88 I got to this part. See, my table1 and table2 contains many columns. For simplicity, I only posted 1 and 2 columns for the table.
What I'm trying to understand right now is do I list all the column names in table1 and table 2? See highlighted text in red. Also, where did you get 'EmployeeName' when the column names in both tables in PBIX are 'Employee Name'.
Table1.Join(
#"Table2", "Employee Name", Can I include more columns from Table 2?
Table1.RenameColumns([Rows],
{"Employee Name", "EmployeeName"}), Can I include more columns from Table 1?
"EmployeeName", JoinKind.LeftAnti)