Forum Discussion
Merge Query against a range
Hi All, I am trying to find an efficient design pattern to do a merge join in Power Query where the join is not a striaght forward equality join. I have a table containing sales data and for ...
One way to speed up execution is to leverage the fact that the dates are sorted in the lookup list and in the sale date lists of the various products.
In this way, the lists are "traversed" only once.
This in M could be done with the List.Generate function.
What size are your tables.
How many products, how many sales and how many changes in cost?
have a look at this ...
for the "dirty work" I used list.accumulate which is perhaps more efficient than list.generate.
One can still tighten something, if you find it a proposal "close" to your needs.