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.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
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.