Power Query using Historical Pricing Lookup Many to Many Data relationship
Solving a problem with wanting to lookup the historical price of an item at the date at which the transaction 'Fact' data records.
This uses Power Query, Bridging Query, and a Measure in the Data Model to achieve this.