Forum Discussion

AndrewJames's avatar
AndrewJames
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Extract 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.                ...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    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

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    AndrewJames
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago

    Thanks J. It worked.