Forum Discussion
Output based on different Columns
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 |
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 🙂
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")
6 Replies
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 - 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.
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 🙂
Thanks, this worked on my other table lol. Appreciate it
