Forum Discussion
Power BI HLOOKUP Equivalent - Data Spread Across Multiple Columns
Hi there brains trust! I am working with a dataset containing questionnaire responses, with questions and answers not being consistently captured. Question 1 always corresponds to Answer 1, ...
danextian
Super User
Super UserHi Jay_D
The third query assumes that the actual raw data columns follow this nomenclature: Question 1 Answer 1 Question 2 Answer 2 so on and so forth. Otherwise you'll have to use the other options.
I will just create a different query for connecting to the data source and then change Source step to reference to that query. Delete everything from Source step and replace it with the external query name. Make sure that the end result of that query is similar to the original Source step and the first column in Person. You can rename it to something else later.
