Extract the highest value from a cell in a column

[AndrewJames]

Hi Team, 

I have a column with multiple values seperated by commas. I would like to create a new column that has the highest value. Any help? Below is the sample image. 

Thanks in advance.

Regards,

Andy.

[tex628 · Accepted solution]

Hi! 

Use replace value to remove the spaces between the numbers and then add this custom column:

List.Max(List.Transform(Text.Split([Column1],","), each Number.FromText(_)))

Br,
J

[AndrewJames]

Thanks J. It worked. 

[amitchandak]

Add an index column, Unpivot, Take max based on index

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448

https://radacad.com/pivot-and-unpivot-with-power-bi

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[AndrewJames]

Hey @amitchandak , Thanks for the reply. But I am not sure how creating an index column would solve this issue. Creating a index column would help me sort the exsiting values. But, I was expecting an answer with extraction of numbers using a delimiter (,) and some sort of condition to return the highest value. 

If I am missing something in your explanation, could you elaborate it a bit?

Thanks. 

Regards,

Andy. 

[amitchandak]

yes split by delimiter will help, Now you can create new columns or rows. In case you want to prefer new rows. You needed to have an id  for the row to trace back. that where I wanted an index column.

For split by delimiter 

The option is under data transform.

Also you can try like

https://community.powerbi.com/t5/Desktop/Splitting-multiple-columns-using-delimiter/td-p/438358