Forum Discussion
Compare two sets of data
Hello All - I'm new to PowerBI and I apologize in advance if this in the forum already and I missed it! I have 3 different data sets (Table_AVI, Table_IND, Table_Zip) and each have a FullName col...
jthomson
Solution Sage
Solution SageGot to be some tricks you can do in Power Query for this one. You could:
- hack down IND and Zip to a single column with just the names
- add a custom column to IND that just says IND in every row and one in Zip that just says Zip
- Merge IND and Zip together on the name, add a column with conditional logic saying if the IND column's blank then Zip, else if the Zip column's blank then IND, else Both
- Merge that into AVI
Probably more efficient ways to do this but that should work