Forum Discussion

Lobs's avatar
Lobs
Helper II
5 years ago
Solved

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?   Em...
  • Lobs's avatar
    Lobs
    5 years ago

    Hi Greg,

     

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

  • Fowmy's avatar
    Fowmy
    5 years ago

    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's avatar
    amitchandak
    5 years ago

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

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
Lobs
Helper II
5 years ago

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