Forum Discussion

evadung's avatar
evadung
Frequent Visitor
3 years ago

Day with latest time

Hello,  I have this table. I want to have items with date and latest time. See example. Any idea how to do it? Item Date Amount A 1.3.2023 15:03 1 A 1.3.2023 9:31 8 A 1.3.2023 6...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
3 years ago

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bc7NDcAgCAbQVRrPxgiIVm5txzDuv0axJCZtvcH3wk9r7nDeQaCAEWkDlkgjcN1/qAqB9vtfssSofZqCHNCoCLMGvCCdShrQQ+fYNwmywLhVVgZ2bTnHZvb9pVWdhII0P3lRFc62sN8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Item = _t, Date = _t, Amount = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type text}, {"Date", type datetime}, {"Amount", Int64.Type}}),

    #"Added Dt" = Table.AddColumn(#"Changed Type", "Dt", each Date.From([Date])),
    Grouped = Table.Group(#"Added Dt", "Dt", {"Grp", each Table.Max(_, "Date")}, 0),
    #"Expanded Grp" = Table.RemoveColumns(Table.ExpandRecordColumn(Grouped, "Grp", {"Item", "Date", "Amount"}), "Dt")
in
    #"Expanded Grp"