Forum Discussion

oceany's avatar
oceany
Frequent Visitor
3 years ago

Getting a minimum number from a list with a condition

Let us say my table has two columns: Start & End List.  1. Start (Integer) 2. End List (List) The length of End list is not fixed and may vary depending on each row.    Let us say, Row #1'...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Right function in this scenario is List.Skip

 

List.Skip([End List], (x)=> x < [Start]){0}

To use your formula

List.Select([End List], (x)=> x > [Start]){0}

 

To handle errors

 

try List.Skip([End List], (x)=> x < [Start]){0} otherwise null