Forum Discussion
Transpose table
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.
Anonymous 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.
Thank you parry2k
What about using summarize with VAR to create two tables with new additional columns "Quarter" and "Value"
Then using UNION to combine the 2 tables.
I managed to get this done and works perfect.
Not sure what will happen if the source table will get more data into it
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.
Thank you very much for detailed clarification
Franckly a colleague who is like me very new to Power BI alreay started and built a lot with row data from Excel file..and will not be happy to start all over again by unpivoting data.
Thats why I figured out this dax approach as data set is very small
Reagrds,