How to create a "Between Join"

Question

Hi, I have a requirement.&nbsp;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&nbsp; "Advanced Purchase days" -&gt;"High_value" and "Low_Value", how to do that in front End, not in DB?

lbendlin · Answer

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

amanawesome · Answer

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

lbendlin · Answer

try using TREATAS and CALENDAR as the filter in your measure

Forum Discussion

3 Replies

Related content