How to create a "Between Join"

Hi, I have a requirement.  I have one Fact table which of Direct Query Mode with a column called "Advanced Purchase days" and one Dim Table which is of Import Mode with columns like "High_value" and...