INNER JOIN with BETWEEN

[joshua1990]

Hi all!

I am trying to rebuild a SQL in Power BI as a data model.

I was able to rebuild all Left Joins but stucked by a INNER JOIN that has a BETWEEN statement:

INNER JOIN Table1 ON (Table2.ID =Table1.ID and Table2.ID2 between Table1.ID_A and Table1.ID_B)

How would you rebuild this in a DataModel?

[lucadelicio]

Hi Joshua,
try to reference the Table1 and filter it with the value that you need (x > id_a and x < id_b) on the specific column
Use this result table to do the inner (function merge query) between the table2 and the new table1 filtered (that contains only the value between you want to do the inner).
If you can post the pbix i can do it for you.
Thank you
Luca D'Elicio