Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Alternative to MAX

is there any function which gives us max of values in terms of strings? not integer 0's and true or false it should return the column value.
Need Help
  • OwenAuger's avatar
    OwenAuger
    9 years ago

    Hi Anonymous,

     

    That's right, LASTNONBLANK/FIRSTNONBLANK order text lexicographically.

     

    If you want the text value with greatest length, you can do this or something similar:

    Longest Text Value =
CALCULATE (
    LASTNONBLANK ( MyTable[TextColumn], 0 ),
    TOPN ( 1, VALUES ( MyTable[TextColumn] ), LEN ( MyTable[TextColumn] ) )
)

    If there are ties, they are broken by LASTNONBLANK.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi OwenAuger,

    Actually i found this blog after a little search.

    Anyway thank you so much for your reply.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi OwenAuger,

       

      The LastNonBlank and FirstNonBlank fuctions giving me the first and last nonblank strings but i need values with maximum character length in the column.!!

      • OwenAuger's avatar
        OwenAuger
        Super User
        9 years ago

        Hi Anonymous,

         

        That's right, LASTNONBLANK/FIRSTNONBLANK order text lexicographically.

         

        If you want the text value with greatest length, you can do this or something similar:

        Longest Text Value =
CALCULATE (
    LASTNONBLANK ( MyTable[TextColumn], 0 ),
    TOPN ( 1, VALUES ( MyTable[TextColumn] ), LEN ( MyTable[TextColumn] ) )
)

        If there are ties, they are broken by LASTNONBLANK.