Join or add column based on multiple date range and categories

Hey All, 

I'm working with two tables that contain 44k rows of data from Dataverse and an API web call. One table has the customer information and the type of service they had during a period. The second is a table which shows all the data time entries by everyone. 

CRM Data Verse

API

I created a list first, which on query editor works as expected, but it's ridiculously slow to load on refresh as it's almost manually checking on each 44k row.

List.First(
Table.SelectRows(
Contract,
(r) =>
r[StartDate] < [CreatedDate]
and
r[EndDate] > [CreatedDate]
and
r[Customer] = [Customer]
and
r[ServiceType] = [ServiceType]
)[ContractName]
)

Is there a way to add a column to the second table on the data model based on multiple conditions between X date that matches multiple columns and returns a string value that's a quicker way to join? Like the below?

API