Forum Discussion
Unpivot calculated columns using DAX query
Hi, I have the following columns User Critical Use 1 Critical Use 2 Critical USe 3 Critical Use Critical Use Calc Creative 1 Creative 2 Creative_Calc Creative ABC 40 40 30 3...
could you pls provide some sample data?
Please see example below:
Response 1, 2, 3, 4 and 5 are original columns. The remaining columns are calculated columns. I would like to pivot the data using the calculated columns to obtaing the resultant table:
User Response 1 Response 2 Response 3 Response 4
Response 5 Critical Use 1 Critical Use 2 Critical USe 3 Critical Use Critical Use Calc Creative 1 Creative 2 Creative_Calc Creative ABC Adopting Performing Adopting Leading Experienced 40 40 30 33.6 Adopting 40 60 50 Adopting DEF Adopting Leading Performing Adopting Performing 40 60 40 46.67 Exploring 60 60 60 Performing GHI Performing Experienced Leading Performing Adopting
40 20 20 26.67 Exploring 20 60 40 Adopting how you get the critial user 1 to the end? i think based on the first 5 columns, we can't get that output. I think we need to transpose and create measures instead of the calculated columns.
