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.
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
Super UserAnonymous 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.