Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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 .
You can use the function "List.Max"
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