Minimum N values from a column

[proficient]

Hello all,

How can I get 5 smallest values from a column in power query.

The column name is "Runs".

Thanks.

 

[alansidman]

Sort Ascending and then remove all other rows.

 

[proficient]

Need an M query to get the result. Numbers are not in sequence. It changes all the time.

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Sorted Rows" = Table.Sort(Source,{{"Runs", Order.Ascending}}),
    #"Added Index" = Table.AddIndexColumn(#"Sorted Rows", "Index", 1, 1, Int64.Type),
    #"Filtered Rows" = Table.SelectRows(#"Added Index", each [Index] <= 5)
in
    #"Filtered Rows"