Help with Measure

[WAYNE_TAI]

How do you create a chart from a table like this

From	To	Qty
Country A	Country B	1
Country A	Country B	2
Country C	Country B	3
Country C	Country B	4
Country A	Country C	5
Country B	Country A	6

<colgroup><col span="3"></colgroup><tbody>
</tbody>

Into one that is based on this?

	From	To
Country A	8	6
Country B	6	10
Country C	7	5

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

in Power BI / Excel?

I have a few other attribute that I need to incorporate, like MOT (mode of transportation), period etc.

 

[Matt Allington]

I would reshape the data in power query. Append both country columns into a single column and add a direction column. So you would end up with this.

country, direction, amount

then load to power pivot or power bi and pivot the data (Pivot table for Excel or Matrix for power bi