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