Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
In my table i have a few columns that have different solutions, which was derived from our survey. Is there a way i can capture those solutions into 1 column so i can get their mix?
Employee | Solution 1 | Solution 2 | Solution 3 | Solution 4 | Chosen Solution |
1 | x | Solution 2 | |||
2 | x | Solution 3 | |||
3 | x | Solution 1 | |||
4 | x | Solution 4 |
Solved! Go to Solution.
Hi Greg,
i can't, the solutions are calcualted columns based on the employee's different entries in the survey.
@Lobs
In Power Query, right click on employee Column, Select Unpivot Other columns,
Filter VALUE Column = x and delete VALUE column
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Lobs , see if this column calculation can work
switch(true(),
not(isblank([Solution 1])), "Solution 1",
not(isblank([Solution 2])), "Solution 2",
not(isblank([Solution 3])), "Solution 3",
"Solution 4")
@Lobs , see if this column calculation can work
switch(true(),
not(isblank([Solution 1])), "Solution 1",
not(isblank([Solution 2])), "Solution 2",
not(isblank([Solution 3])), "Solution 3",
"Solution 4")
Thank you this worked. I also learned the UnPivot too, which i used on my other table.
@Lobs
In Power Query, right click on employee Column, Select Unpivot Other columns,
Filter VALUE Column = x and delete VALUE column
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thanks, this worked on my other table lol. Appreciate it
@Lobs - I would unpivot your Solution columns in Power Query.
Hi Greg,
i can't, the solutions are calcualted columns based on the employee's different entries in the survey.
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |