Forum Discussion
Transpose table
Hi All, Is it possible in Power BI "not via power query unpivot" to transform the below table to the other format Table1 FirstName LastName Q1 Q2 AA BB 1 3 CC DD 5 7 ...
Anonymous yes doing with DAX using summarize not a bad option but why not use power query when it has in-built function to do the job.
Doing wiht power query will have better compression and performance in vertipaq enqine but that all depends on how big is your dataset?
Anyhow I will leave that decision with you, you have both the choices. You can do performance test to figure out what works best.
parry2k
Super User
Super UserAnonymous I don;t think so, it is better to unpivot data in Power Query then you can use pivot or unpivot in desktop using matrix or table visual.