Forum Discussion
Xlookup shifts if I add a column to the query
I have a query table that I'm referencing using an xlookup function on another table. When I add a column to the query, any xlookup gets shifted over one column. =XLOOKUP ("Value", Querytable[Column...
How exactly are you "inserting a column in the Power query editor". Tried several ways (splitting a column between the first and the fourth, adding a column and then arranging it in between). No matter what I do, the XLOOKUP formula keeps the reference to the return_array [Column4].