Latest value by key column

let
    Source = your_table,
    names = List.Buffer(List.Skip(Table.ColumnNames(Source), 2)),
    f = (tbl) => 
        [sorted = List.Skip(Table.ToColumns(Table.Sort(tbl, "Date")), 2),
        rec = Record.FromList(
            List.Transform(sorted, (x) => try List.Last(List.RemoveNulls(x)) otherwise null),
            names
        )][rec],
    group = Table.Group(Source, "ID", {"x", f}),
    xp = Table.ExpandRecordColumn(group, "x", names)
in
    xp

Hi TTS, different approach here:

Enter column names you want to calculated MAX here:

Result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTIyMDLRNTAEIiAnLDGnNBWDjtWJVjLCpRSEQAqM0RVAEMIEZMuMDGBSRkhGGKGrQFYEZaBbhVNdLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Date = _t, Column1 = _t, Column2 = _t, Column3 = _t]),
    // You can probably delete this step.
    ReplaceBlankToNull = Table.TransformColumns(Source, {}, each if _ = "" then null else _),
    ChangedType = Table.TransformColumnTypes(ReplaceBlankToNull,{{"ID", Int64.Type}, {"Date", type date}}),
    __EnterColumnsHere__ = {"Column1", "Column2", "Column3"},
    GroupedRows = Table.Group(ChangedType, {"ID"}, {{"MaxValue", each 
        [ a = List.Transform(__EnterColumnsHere__, (x)=> List.Max(Table.Column(_, x))),
          b = Table.FromRows({ {[ID]{0}} & a }, {"ID"} & __EnterColumnsHere__)
        ][b], type table}}),
    CombinedMaxValue = Table.Combine(GroupedRows[MaxValue])
in
    CombinedMaxValue