How to get data from the lastest file?

Hi Oliehoek ,

How about this? 🙂

Before:

After:

Here the code in Power Query M that you can paste into the advanced editor (if you do not know, how to exactly do this, please check out this quick walkthrough)

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmDSBEyagkkzMGkOJi2UYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [YourColumn = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"YourColumn", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([YourColumn] = List.Max(#"Changed Type"[YourColumn])))
in
    #"Filtered Rows"

The idea is to filter your column with the maximum of that exact column. Note "Changed Type" needs to be substituted with the previous step in your query.

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/