Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unpivot columns using dax

Hi there, I've created a table using data from an imported table and since I've created this table using DAX, I can't manipulate it in the power query editor. I'd like to unpivot all the columns I'v...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    A simple example. Hope this is helpful.

    Table 2 =
VAR t1 =
    SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store1", "Value", [Store1] )
VAR t2 =
    SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store2", "Value", [Store2] )
VAR t3 =
    SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store3", "Value", [Store3] )
RETURN
    UNION ( t1, t2, t3 )

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

A simple example. Hope this is helpful.

Table 2 =
VAR t1 =
    SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store1", "Value", [Store1] )
VAR t2 =
    SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store2", "Value", [Store2] )
VAR t3 =
    SELECTCOLUMNS ( 'Table', "Date", [Date], "Store", "Store3", "Value", [Store3] )
RETURN
    UNION ( t1, t2, t3 )

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.