Unpivoting columns in DAX

Unpivoting columns means that the unpivoted column values become new rows in a table. Unpivoting columns is generally handled in Power Query. However, there are documented cases where unpivoting columns in Power Query causes performance issues, particularly when unpivoting columns coming from a SharePoint list.

This recipe demonstrates how to unpivot columns using DAX instead of Power Query.

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 R03_Table that contains the following data:

Date	Column1	Colum2	Column3	Column4	Column5	Column6	Item
1/1/2018	Greg	Jason					Meeting 1
1/5/2018 ...