How to create a "Between Join"

[AmanAwesome]

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 "Low_Value". Now I need to create a "between join" with  "Advanced Purchase days" ->"High_value" and "Low_Value", how to do that in front End, not in DB?

[lbendlin]

You posted this question in the Power Query section. Did you mean to ask for help with a measure instead?

[AmanAwesome]

Yes, is there any way to create the join. I would really appreciate if it could done by a measure. Thanks !

[lbendlin]

try using TREATAS and CALENDAR as the filter in your measure