Solved: How to transpose a table in BI?

ericbi · ‎03-27-2018

Hi,

I have report on the left side below, all the values are measures. I want to make the table like the one on the right side.

I've tried many ways but can't transpose the table. can you help me?

ImkeF · ‎03-27-2018

In the query editor you have to demote your headers first:

and then transpose:

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎03-27-2018

In the query editor you have to demote your headers first:

and then transpose:

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Greg_Deckler · ‎03-27-2018

This looks like a problem for @ImkeF.

If you could post sample data in a form rhat can be copied, that would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

How to transpose a table in BI?