Forum Discussion

Katalo's avatar
Katalo
Frequent Visitor
8 years ago
Solved

Filter with row value as column name

Hello!

Im trying to combine two tabels, one question table with question codes as rows, and one answers table with question codes as column headers and answers in the rows. Im trycing to create another coumn in my questions table with a count of specific values from the answers tabel. 

 

Is it posible to use a row value to select a column in another table. How does that syntax look like?

 

For example:

 

COUNTROWS(filter(Answers,Answers[ <-- Questions[row value] -->     ]=5))

  • to my knowledge it's not possible
    I would suggest unpivoting answers in the query editor to have them in rows, then the filtering is really easy

1 Reply

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion

    to my knowledge it's not possible
    I would suggest unpivoting answers in the query editor to have them in rows, then the filtering is really easy