Forum Discussion

RAKESH1986's avatar
RAKESH1986
Icon for Helper II rankHelper II
3 years ago
Solved

how to take column max value in another new column

Hi all,   i have these two colum and i want to take max value for this column in new column..   here my max value is 113407 and i want to paste this in new cusotm column... this max value keep o...
  • ronrsnfld's avatar
    3 years ago

    Add a custom column with thi formula in the Dialog box:

     

    =List.Max(#"Previous Step"[Column Name])

     

    Replace `Previous Step` with the name of the step preceding where you are adding the column

    Replace `Column Name` with the name of the column you want the Maximum of

  • css207's avatar
    3 years ago

    You can use the function "List.Max"