Inserting Excel matrix into Power BI table

[Anonymous]

I currently have a slicer where the user selects the origin and a list of destinations are shown with their distance in miles. I am wanting to add another column after distance to be days to destination from the one origin to all the destinations. This information is housed in an excel matrix and I am unsure how to add it to the table as a column. There are photos below showing the slicer and table and also the excel matrix. Any information would be greatly appreciated.

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue on your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. If not, please kindly elaborate more. thanks!

[amitchandak]

@Anonymous , the data you shared and the output you want I am not able to relate. It needs to copy two to display this .

Can you share sample data and sample output in table format?

[lbendlin · Accepted solution]

One option is to unpivot your Excel matrix to arrive at a table with these columns 

Place A     Place B     Distance

For simplicity you may want to repeat the table with Place A and Place B swapped.

Then you can link that to your other tables.

[Anonymous]

I followed your advice. Thank you!