none
Max Number Across Columns RRS feed

  • Question

  • Hi guys

    I have an 8 column table with decimals in it. I'd like to know how to add a custom column to pull through the max value for the specified columns, i.e. in Excel it would be =MAX( Table1[ [Column2] : [Column8] ] ).

    For example:

    Name Column2 Column3 Column4 Column5 Column6 Column7 Column8
    Bob 8.1 1.3 2.3 null -6.4 2.1 4.5

    Would turn into:

    Name Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9
    Bob 8.1 1.3 2.3 null -6.4 2.1 4.5 8.1


    Thanks!
    Simon

    Wednesday, April 27, 2016 9:18 PM

Answers