Output with max value from each row of a column

[Anonymous]

Below table shows my input column and intended output column. For each row, I would like to have the max value as the output in the corresponding column.

There are instances where both values are same (e.g. row 4 in the below table), then the output should be one of the two numbers.

Input Column	Required Output
2,4	4
18,11	18
15	15
10,10	10
3,6,7	7
5	5

[amitchandak · Accepted solution]

@Anonymous 

It can be better done in M. Means you have to use Edit Query/data Transformation Mode.

create a custom column like

Required Output
= List.Max(Text.Split([Input Column], ",") )

[Anonymous]

It worked. Thanks a lot 😊