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 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
Super User
Super UserYup 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.