how to take column max value in another new column

[RAKESH1986]

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 on changing..pls help me to solve this issue

thanks

[ronrsnfld · Accepted solution]

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

[VishalJhaveri]

Hello @RAKESH1986 ,
Please check this answer already provided on community by other member: Solved: Max value from a column in Power Query Editor - Microsoft Power BI Community
PS: @ronrsnfld has already answered your question, but this question was already posted with an explanation with photo .

[css207 · Accepted solution]

You can use the function "List.Max"

[ronrsnfld · Accepted solution]

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