Unpivot without using Power Query

[maqsud]

I have the below table created using the DAX formula and want to unpivot column without using Power Query.

Table name: Demo

Access code (Unique Column)	Column A	Column A
1	0.87	0.74
2	0.87	0.74
3	0.87	0.74
4	0.87	0.74

Required Table: Result

Access code (Not unique in this table)	Name	Value
1	Column A	0.87
1	Column B	0.74
2	Column A	0.87
2	Column B	0.74

[amitchandak]

@maqsud , refer

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[mahoneypat · Accepted solution]

This is something that definitely should be done in the query editor, if possible.  Why do you need it in DAX?

In any case, here is a DAX expression that will generate your Calculated Table

Union Table =
VAR TableA =
    SELECTCOLUMNS (
        'Union',
        "Access Code", 'Union'[Access Code],
        "Value", 'Union'[Column A],
        "Column", "Column A"
    )
VAR TableB =
    SELECTCOLUMNS (
        'Union',
        "Access Code", 'Union'[Access Code],
        "Value", 'Union'[Column B],
        "Column", "Column B"
    )
RETURN
    UNION ( TableA, TableB )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat