Hello,
Is there a way to do a vlookup/lookup value calculation in the query editor using M Language? I believe the Merge function is one way to acheive this. However in my dataset that I am trying to bring data into contains duplicates. The dataset I am looking the data up in also contains duplicates so I get an error with the Merge. Generally speaking I understand I shouldn't have duplicates in both data sets however the value I am trying to retreive via vlookup/lookup value is the same regardless of the duplicate values. I cannot group or otherwise parse my query dataset down to exclude duplicates because I need this data for other visuals in my model. I could create another query I realize but then I have to make the data sets related in order to make my already complex model function correctly so I belive the lookup value is the easiest. I understand I can do this in DAX but I wanted to know if I could do it in the Query Editor also.
Thanks in advance!
