Forum Discussion

GioVille's avatar
GioVille
Regular Visitor
3 years ago
Solved

Extracting Maximum number in string

Hello,    Is there a way to extract the maximum number in a string into a new column.   The number represents the number of attempts the test was conducted until I got a passing result.    ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Custom",each List.Count(Text.Split([StatusColumnName],","))/2)

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

NewStep=Table.AddColumn(PreviousStepName,"Custom",each List.Count(Text.Split([StatusColumnName],","))/2)