Forum Discussion
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
Community 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