Forum Discussion

Sadath's avatar
Sadath
Icon for Helper I rankHelper I
5 years ago
Solved

List.Select issue

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 Sale...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this instead

     

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

     

    Regards,

    Pat

Sadath's avatar
Sadath
Icon for Helper I rankHelper I
5 years ago

Hi

Thank you, code working fine...

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