Forum Discussion
Microsoft EmployeeExtract the highest value from a cell in a column
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.
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
5 Replies
- tex628
Community Champion
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
Super User
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
