Transposing tables

Transposing tables means that the columns in a table become rows and the rows in a table become columns. Transposing tables is necessary for certain mathematical operations such as matrix multiplication. Excel has a handy function called TRANSPOSE that performs such an operation in a single function statement. In addition, Power Query can also be used to transpose a table in a single operation. Unfortunately, DAX has no equivalent TRANSPOSE function.

This recipe implements a table transpose using DAX.

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R04_Table that contains the following data:

Column1

Column2

Column3...