Extract list value and calculate value of a list

[Bit2021]

I have some columns that the value is a list. I can extract values and separate them with a comma, like the below screenshot:

In each list, there are 10 values in this sample all of them are 0.

Now, I want to know is there any way to calculate the value of the list like find MAX or MIN? Without extract or extract?

[HotChilli]

List.Max  and pass the list as a parameter e.g. Add a custom column , put List.Max and the column in brackets

[PhilipTreacy · Accepted solution]

Hi @Bit2021 

Download example PBIX file

Yes, add a Custom Column and use the List.Max, List.Min etc functions : List functions - PowerQuery M | Microsoft Docs

Here's a new column calculating the Max of the lists in the Value column

Here's a whole query for Max, Min and Sum

let
    Source = Record.FromList( {{0,1,2,3,4,5,6,7,8,9}} , {"Latitude"} ),
    #"Converted to Table" = Record.ToTable(Source),
    #"Removed Columns" = Table.RemoveColumns(#"Converted to Table",{"Name"}),
    #"Added Custom" = Table.AddColumn(#"Removed Columns", "Max", each List.Max([Value])),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Min", each List.Min([Value])),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Sum", each List.Sum([Value]))
in
    #"Added Custom2"

Regards

Phil