Take maximum number from a column which has a list of a list

[Ashish_Mathur]

Hi,

In the image, you can see that the Custom column is a List of a List.  Each list within a list has a set of numbers.  My objective is to take the Maximum of each list within the list.  How can this be done?

Thank you.

[Ahmedx]

if you want a maximum maximum even further, then I think they can handle it themselves

Table.AddColumn(

Table.FromColumns({[Custom]}),"MaxValue",

(x) => List.Max(x[Column1])

)[MaxValue]

[Ashish_Mathur]

Thank you for replying but that is not the result i want.  In the Custom.1 column, i want to see 45 in the first row i.e. the maximum of each list of numbers within that row's list.

[Ahmedx]

I didn't understand, can you explain how 45 should be in the first line

[Ashish_Mathur]

Hi,

When you click on the first list entry under the Custom column of Row 1, you will see 4 numbers in the data pane below - 40,45,33,38.  The maximum of these numbers is 45 and that is what i want to see either in the Custom.1 column of row 1 or in the Custom column itself.  The same logic is for the other rows as well.

[Ahmedx]

Excuse me again, something is not clear, or I have other numbers 24.5, 31.40
, pin the screenshot

[Ashish_Mathur]

Hi,

Sorry for the confusion and thank you for offering a helping hand.  In the screenshot that you shared with me 4 hours ago, you will see those numbers.

[Ahmedx]

Is this what you are looking for?

[Ahmedx]

Share sample pbix file to help you.

[Ashish_Mathur]

Hi,

Please find attached.