Forum Discussion

Sadath's avatar
Sadath
Helper 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

mahoneypat's avatar
mahoneypat
Microsoft Employee
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