Transpose table via DAX?

[Matty]

Hi Team,

Is it possible to do the following via DAX?

Table now:

[TABLE="width: 412"]
<tbody>[TR]
[TD]Div[/TD]
[TD]Date[/TD]
[TD]HomeTeam[/TD]
[TD]AwayTeam[/TD]
[TD]HomeGoals[/TD]
[TD]AwayGoals[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]


Table wanted:

[TABLE="width: 371"]
<tbody>[TR]
[TD]Div[/TD]
[TD]Date[/TD]
[TD]Team[/TD]
[TD]Place[/TD]
[TD]Goals[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]A[/TD]
[TD]Home[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]B[/TD]
[TD]Away[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]C[/TD]
[TD]Home[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]D[/TD]
[TD]Away[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]E[/TD]
[TD]Home[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]26/08/2017[/TD]
[TD]F[/TD]
[TD]Away[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

I know how to do this is VBA and SQL, but not DAX. Can anyone help?

Cheers,

Matty

 

[Matt Allington]

You should use Power Query. Load the data and then select transform/unpivot

 

[Matty]

You should use Power Query. Load the data and then select transform/unpivot

Thanks for your suggestion, Matt. Power Query looks extremely useful for transforming data prior to analysis.

Cheers,

Matty