Table join along with a date comparison. conditional calculation

Hi lbendlin 

I have removed that sorting step as it might have been added when developing and testing the transformations. But removing that step does not help right now as the Source step itself is never getting back with data.

The data source is Sharepoint folder. Two tables based on different criterias are created first in PowerBI and they are fine with now issues. The above presented code is for the 3rd table which is basically a join between the first 2 tables on SKU. But the join should also be accompanied by the date between condition.

Now with small sample data files, this code was running fine but with larger number of files and data, the first step is equivalent to a cross-join as the Date between condition cannot be included together with the join.

So, I want to know how to better process this type of join with a condition in PowerBI.

Thank you!