Max date in power query

Hi topazz11 

If you have a finite number of date columns, you could try adding a custom column something like this.

if [date1] > [date2] then 
    if [date1] > [date3] then [date1] else [date3]
else 
    if [date2] > [date3] then [date2] else [date3]

If you aren't sure how many dates in a record, that makes things tougher.

Let me know if this helps.

Hi,

This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"id", Int64.Type}, {"date1", type datetime}, {"date2", type datetime}, {"date3", type datetime}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each List.Max(List.Skip(Record.ToList(_),1)))
in
    #"Added Custom"

Hope this helps.