Forum Discussion
yosemite
Helper III
Helper IIILOOKUPVALUE - 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
camargos88
Community Champion
Community Championyosemite ,
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
yosemiteHelper III
Helper III