Forum Discussion
Power BI HLOOKUP Equivalent - Data Spread Across Multiple Columns
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.
danextian thank you for that. I meant to mention that my actual source is a database View. Am I still able to apply the same steps that you mention here?
- danextian
Yup but you won't be able to use Direct Query. I would still use an external query to connect to the database and make sure that end result looked similar to the original source step.