Unpivot the multiple measure to column

[Anonymous]

Hi Users,

I have facing issue in Unpivoting the measure to column, The below output i wanted achive using DAX.

i have measure field with values and wanted to show this in column.

A	B	C
10	20	3
output
A	10
B	20
C	30

Thanks,
Raj

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may use below dax to create a table.

Table =
UNION (
    SELECTCOLUMNS ( Table1, "Output", "A", "Value", [A_Measure] ),
    SELECTCOLUMNS ( Table1, "Output", "B", "Value", [B_Measure] ),
    SELECTCOLUMNS ( Table1, "Output", "C", "Value", [C_Measure] )
)

Regards,

[Anonymous]

@Anonymous - 

In DAX, you can use UNION, as done here.

In Power Query, there is an Unpivot function, if that is an option. 

Hope this helps,

Nathan