Forum Discussion
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 "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?
3 Replies
You posted this question in the Power Query section. Did you mean to ask for help with a measure instead?
Yes, is there any way to create the join. I would really appreciate if it could done by a measure. Thanks !
try using TREATAS and CALENDAR as the filter in your measure
