Forum Discussion
Solved
Vlookup without a calculated column
I have a header table and a fact table linked on 'Item' but I know there are orphaned items in the fact table that do not exist in the header table.
In excel I would do a vlookup to find the missing items. In PBI I do not like to use calculated columns unless I really need them.
How do I do this in a table visual WITHOUT using a calculated column?
Nevermind, the regular lookupvalue formula works in a table visual. I was getting an error due to a different issue.
1 Reply
Nevermind, the regular lookupvalue formula works in a table visual. I was getting an error due to a different issue.