Output based on different Columns

[Lobs]

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

[Lobs · Accepted solution]

Hi Greg,

i can't, the solutions are calcualted columns based on the employee's different entries in the survey. 

[Fowmy · Accepted solution]

@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 🙂

YouTube, LinkedIn

[amitchandak · Accepted solution]

@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]

Thank you this worked. I also learned the UnPivot too, which i used on my other table.

[Fowmy · Accepted solution]

@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 🙂

YouTube, LinkedIn

[Lobs]

Thanks, this worked on my other table lol. Appreciate it

[Greg_Deckler]

@Lobs - I would unpivot your Solution columns in Power Query.

[Lobs · Accepted solution]

Hi Greg,

i can't, the solutions are calcualted columns based on the employee's different entries in the survey.