Index not referencing new columns|Power Query|Excel Forum|My Online Training Hub

Hi

Im using  index to look up offset values, and as this was slowing the refresh, a contributor here called Catalin Bombea (A true hero) suggested using Table.Buffer, and this works brilliantly.

That is until i create new custom columns which calculate values using the index, and then add a new column that references one of these other custom columns - at which point i get an error telling me it cannot find the column being referenced - by trial and error i have established that this is because the Index offset can only reference columns buffered at the time of creating the buffer. 

To be able to reference one of the custom columns using and offset, i have added a second index column and used Table.Buffer but regardless the refresh not takes a looooong time.

So the questions in my head are:

1- Can i add the calculated custom columns to the existing buffer so i dont have to use a second index.

2 - Is there a better way to use Table.Buffer on a second index.

3 - Can you remove / clear an existing buffer before invoking a second buffer.

Hope this makes sense and any help or pointers gratefully received.

Dave