Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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's Start=1 and End List = {3, 4, 9, 11, 35}
I would like to get 3 in a new column since 3 is the minimum number while being greater than 1.
Row #3's start=4. If its End List ={2, 3, 6, 10}, I would like to get 6.
I am trying List.Select, but this function gives an error.
= Table.AddColumn(#"Expanded Start List", "Custom", each List.Select([End List], each _ > [Start]))
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 14 | |
| 14 | |
| 10 | |
| 8 | |
| 8 |