Forum Discussion
Vlookup/Lookup Value in Query Editor/M Language
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 try...
Merge is the way to go. Duplicate the query where you want the lookup values and then disable the load so it doesn't come into your model.
Aron_Moore thanks for the reply. If I disable the load will new changes come in? The query I am specifically thinking about is a list of employees so I need to make sure it is refreshing to add new employess.
Thanks again!
Yes, it will continue to refresh along with your other data. Disabling the load just prevents the table from coming into your model.
See https://community.powerbi.com/t5/Desktop/Getting-rid-of-source-tables-after-append/td-p/154745