Forum Discussion

datawhale's avatar
datawhale
New Member
3 years ago
Solved

Convert rows from multiple columns into a single column

I have the following table:

 

 

I would like to create a single column from the three columns (good, caution, critical) only for value 'b'. The result should be like:

 

(note: id and id_1 are identical)

Need Help

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    This should get you started - just add more if conditions (or use switch) to add in the rest.

     

    Table 2 = SUMMARIZE('Table', 'Table'[id], "status", IF(CONTAINSSTRING(VALUES('Table'[good]), "b"), "Good") )