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.