Output based on different Columns

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 🙂

YouTube, LinkedIn

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")