Forum Discussion
Solved
Transpose and pivot data for calculated columns
The below is the original data: User Response 1 Response 2 Response 3 Response 4 Response 5 ABC Adopting Performing Adopting Leading Experienced DEF Adopting Leading Perfo...
Hi arajan111
In this case, it is better to use Power Query to merge data in order to bring numerical values in your table, and unpivot the wide table after merging the additional numerical columns. Transforming your data to a long narrow table (the type of table which dax can efficienty process and consume), is Power Query's forte.
Best regards,
Hi arajan111
In this case, it is better to use Power Query to merge data in order to bring numerical values in your table, and unpivot the wide table after merging the additional numerical columns. Transforming your data to a long narrow table (the type of table which dax can efficienty process and consume), is Power Query's forte.
Best regards,