Join Tables based on date range - one registration matched with multiple dates

Hello jorge_terere 

Check the attached PBIX, I have created a similar scenario by inducing a CROSS JOIN and then filtering out rows based on your condition(Between start and end) using Power Query.

I do not know the size of your original tables, Power query would be able to manage the cross join without any issues if the table expands to few million rows.

Let me know if this helps and if you have any question.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!