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.