power query calculate max of 4 columns

[Anonymous]

I am in power query. I have 4 date columns. I want to calculate the maximum date.

In DAX, I would use:

max(max([column1],[column2]),max([column3,column4))

How do I do this in power query (when I click on add column and enter a formula), as it will save time and effor later on

Thanks

[v-piga-msft · Accepted solution]

Hi @Anonymous,

You could create a custom column with the query below. Please note that you should create the Index column from 0 firstly.

= Table.AddColumn(#"Added Index", "Custom", each List.Max(Record.ToList(Table.RemoveColumns(#"Added Index","Index"){[Index]})))

Then you will get your desired output.

More destails, you also could refer to the attachment.

Best Regards,

Cherry