Back to Browse

Power Query Merge or Append - Speed Testing

528 views
Nov 21, 2020
11:48

Just a quick test to see which of 2 methods of getting to a solution in Power Query is actually more efficient. I am creating a join between two existing Data Queries, to get the Historical Product Price at the time of the Transaction. A normal relationship is tricky as it is a Many-to-Many relationship and so 'Related' functions won't work. I came up with a Merge solution, and then inspired by Ken Puls (who was inspired by Ox du Soleil) I came up with an Append solution. Here's how I tested them against each other to see which one was quicker.

Download

0 formats

No download links available.

Power Query Merge or Append - Speed Testing | NatokHD