Forum Discussion
Solved
Power BI Excel Index Match help needed
New user here. I have two tables in my Power BI Report. Table 1 is a contact list with addresses. Name Address1 Address2 City State Zip Tom Jones 123 Sesame St Beaverton OR 97003...
Hi jwelch176 ,
In Query Editor, select Zip Code, Closest Location - Distance, Closest Location - Name and use unpivot other columns feature.
Result:
Then use merge query feature.
Expand the table and remove duplicate.
Best Regards,
Jay
Hi jwelch176 ,
In Query Editor, select Zip Code, Closest Location - Distance, Closest Location - Name and use unpivot other columns feature.
Result:
Then use merge query feature.
Expand the table and remove duplicate.
Best Regards,
Jay