Max in Index Column

Question

Is there a formula I can use that finds the MAX value of an index column in the Query?

hotchilli · Answer

Any column in Power Query can be used as a list so List.Max()
You will have to pass the parameter as&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; previous step[ColumnName]

Forum Discussion

Max in Index Column

1 Reply

Related content

Fixed Index Column

dummy index column

Column index

Replace Index Column

Multiple conditions Index