List.Select issue

[Sadath]

Hi

I have a list (SalesList) with sales values

I have another table (Table1) with two column (SalesFrom & SalesTo)

i need a custom column in Table1 ,   filter value from SalesList greter than SalesFrom and less than  SalesTo then count.

and another custom column  filter value from SalesList greter than SalesFrom and less than  SalesTo then Sum.

i tried with first adding  SalesList

= Table.AddColumn(#"Changed Type", "Custom", each SalesList)

then i use filter

= Table.AddColumn(#"Added Custom", "Custom.1", each List.Select([Custom], each _ > [Sales From]))    <this return error

[Sadath]

Hi

Thank you, code working fine...

my SalesList having 10k+ rows  and Table1 having 20 rows, its too slow

[mahoneypat · Accepted solution]

Please try this instead

= Table.AddColumn(#"Added Custom", "Custom.1", each let value = [Sales From] in List.Select([Custom], each _ > value)) 

Regards,

Pat