Forum Discussion
Displaying word greater than 20
Hello I am working on the table screenshot below: I am creating a third column to complement the first two above. Column 1 is if the value column contains a word length greater than or equal...
= Table.AddColumn(#"Added Custom3", "MaxLength Words", each List.Sort(Text.Split([Value]," "),{Text.Length,1}){0})
wdx223_Daniel
Community Champion
Community Champion= Table.AddColumn(#"Added Custom3", "MaxLength Words", each List.Sort(Text.Split([Value]," "),{Text.Length,1}){0})