Forum Discussion

some1else's avatar
some1else
Helper II
5 years ago
Solved

Transpose using DAX and virtual table

Hi guys.   If I were to transpose columns into rows like the image below, how could I achieve it using a virtual table in a measure? I don't want to create a copy of the existing table and store it...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    Hi, some1else 

    The easiest way to get the results you want is to transpose them in the Query Editor.

    Sample data:

    Step 1: Use Headers as First Row

    Step 2: Transpose

    Result:

     

     

    Is this the result you want? Hope this is useful to you

    Please feel free to let me know If you have further questions

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey some1else ,

 

a close approach is the following table:

UNION (
    SELECTCOLUMNS ( myTable, "ID", "A", "Value", [A] ),
    SELECTCOLUMNS ( myTable, "ID", "B", "Value", [B] ),
    SELECTCOLUMNS ( myTable, "ID", "C", "Value", [C] ),
    SELECTCOLUMNS ( myTable, "ID", "D", "Value", [D] )
)

 

Check if that would work, that's more or less a unpivot of the table.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
  • some1else's avatar
    some1else
    Helper II
    5 years ago

    Feeling very dumb right now...

     

    Tried that but no sucess as it gives an error expecting one value only (tried with a measure, because I don't want to physically create columns or new tables).

    Below image with the error and image with table OTs with the columns currently on it.

     

    The idea is to have the WONUM and ZMC in row and the values in columns