Powerbi Transpose set of columns as a ROWS

[revansh]

Hi ,

I have a requirement to traspose specific set of columns to rows.

FOR EXAMPLE: Given below are 7 columns of my dataset.

DIM_COL   M1  M2  M3  M4 M5 M6

i want my table report as:

DIM_COL MI M2 M3

DIM_COL M4 M5 M6

Thanks

[v-chuncz-msft · Accepted solution]

@revansh,

You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.