List.Select issue

[sadath]

Hi

i have piece of code like this which is working fine

= Table.AddColumn(#"Added Custom", "Custom.1", each List.Select([Custom], each _ > 100))

when i reference 100 into a column getting error

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

and how can i add AND condition into this like

each _ > [Sales From] and each _ < [Sales To]

 

[GraH]

Hi,
You can't refer to the original column "Sales From" inside the List.Select iterator as it is "outside" of the list of [Custom], because [Sales From] refers to the first iterator (each) of Table.AddColumn.

You may try this (see the first "each" is missing and we replaced it with a variable "Sales": this "calls" the outside table)

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

If you have a large table, this might will get slow. You can then consider a custom function, with [Custom] and [Sales From] as input variables.