Recreate this SQL JOIN in Power BI

In my SQL Server database, I have a table with our product history joined to our order table.  I'm struggling with how to recreate this join in Power BI. Hoping someone can help me.

The order products are joined to the product table, where the order date is on or after the product "start date" and less than the product history "end date." Current product data always has an end date of '3000-01-01'.  Example is below...

SELECT * FROM orders
LEFT OUTER JOIN product_hist ON orders.product_id = product_hist.product_id
AND (orders.order_date >= CASE WHEN product_hist.batch_id = 1 THEN '1900-01-01' ELSE product_hist.start_dt END)
AND orders.order_date < product_hist.end_dt

I've been forcing the Power BI product table to only show the current data, i.e. showing only the data where the end date is '3000-01-01'. This is obviously wrong once users are pulling historical data.

Thanks, in advance, for your help!