Forum Discussion
BEST PRACTISE: Lookup in interval table
Hi. I have tried to put my challenge simple. Input: FACT Lookup_table Now, what I would like to do is Add column to FACT, where - The FACT[some number] is looked ...
Hi Jimmy
Unfortunately, I have already done this, as I stated in the initial question. The #"Lookup table" query is
let Source = Excel.CurrentWorkbook(){[Name="Lookup_table"]}[Content],
in Table.Buffer(Source)
I have also tried putting the Table.Buffer part in the function itself, and to me it seems the effect is identical - both equally efficient?
Hello Anonymous
I think you have to add the table buffer in the query, where you are merging both of your queries, not in the orignal one
BR
Jimmy