Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have the following table:
I'm trying to make it look like this, by unpivoting other columns except 'Respondent name' and 'Respondend unique ID'.
However I loose respondent 28230144 and city San Antonio. Is it possible to perform unpivot operation while keeping the null values?
Thanks!
Solved! Go to Solution.
Try replacing the null value with a blank space in the four questions columns that you are unpivoting.
After you have done this, select the Respondent Name and Resp ID column and press the "Unpivot Other columns".
This will work to give you the San Antonio result in your Unpivot.
Please give thumbs up and mark this as the solution. Thanks.
Try replacing the null value with a blank space in the four questions columns that you are unpivoting.
After you have done this, select the Respondent Name and Resp ID column and press the "Unpivot Other columns".
This will work to give you the San Antonio result in your Unpivot.
Please give thumbs up and mark this as the solution. Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
50 | |
19 | |
12 | |
11 |