Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Transpose Table in DAX

Hello guys i have an issue, i have a calculated table like this where the values are measures in a another table called "Records" A B C 23 43 56   created using this DAX Expression ...
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    UNION (
    ROW ( "Measure", "A", "Value", [Measure A] ),
    ROW ( "Measure", "B", "Value", [Measure B] ),
    ROW ( "Measure", "C", "Value", [Measure C] )
)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

UNION (
    ROW ( "Measure", "A", "Value", [Measure A] ),
    ROW ( "Measure", "B", "Value", [Measure B] ),
    ROW ( "Measure", "C", "Value", [Measure C] )
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Oh My God, Thank you,

This worked like a dream.

I am so embarassed at how easy the solution was.

 

Again Thank you.