alternative for speed up

[abatahir]

hi, 

I am using the following code after merger two able to populate the data from 2nd table based on the condition. but this code makes the power query very slow, anyone has an alternative for this in Power Query or Power Pivot. 

= Table.AddColumn("subsidy_merger", "Custom", each let SaleDate = [CreatedDate] in
Table.SelectRows( [Subsidy], each [Staring date] <= SaleDate and [Ending date] >= SaleDate))

[Anonymous]

Well I'm pretty sure your "in"statement should refer to a variable from your "let" variables. Are you doing this operation on the nested table column? If so, whatever operation you do is going to iterate over every nested table. You are better off Duplicating this table after the merge, and then applying your date filter, and then expanding your Created Date field, if I am understanding the desired result correctly. I am assuming you need to keep all of the original rows, otherwise you would just apply your filter before the merge...

--Nate

[abatahir]

yes I am using it nested, the first table is the sales table 2nd table is the commission table, the commission on 2nd table is different on each for the same product, So by doing the above-mentioned operation I am expanding 2nd table to get the commission rate of that sale date for each product. 

important both tables have multiple items so it is not unique,