Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
oceany
Frequent Visitor

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. 

2023-07-18 14_43_44-Project Tracking Report_2023.07.12 - Power Query Editor.png

 

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]))

 

 

 

 

 

1 REPLY 1
Vijay_A_Verma
Super User
Super User

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

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors