Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Nevermind, the regular lookupvalue formula works in a table visual. I was getting an error due to a different issue.
Nevermind, the regular lookupvalue formula works in a table visual. I was getting an error due to a different issue.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |