Forum Discussion

jwelch176's avatar
jwelch176
Frequent Visitor
6 years ago
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...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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