Retrieving latest lata extent

Question

HelloI have earlier posted a question about retrieving the latest data. I have gotten answers that did work, however not the way I need it to. Therefore I want to post the question and the entire use of the data. Hopefully someone can help me.&nbsp;I am sitting with a bunch of data. dummy:&nbsp;name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; product1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;product2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; product3xx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/10-2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1aw &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9/11-2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0xx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20/12-2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;I need both the full query, and then I want to retrieve the latest data from that query. The latest data, I want to have the full functions of a normal query. this meaning I can unpivot a column and enter it in a visual etc. &nbsp;So far I have been able to retrieve the latest data and insert it in a matrix and create a DAX table retrieving the latest data. However none of these methods gives me the ability to unpivot columns. Can anyone help me?

anonymous · Answer

BiBra,Add a new blank query and paste the following code to Advanced Editor of the query, then check if you get expected result.
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WqqhQ0lEyNNAHIiMDQzMQxwhEALGBUqxOtFJiOYhrqG8JlzeFyhuC5SEGGAFlYQqMDMCawQbEAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [name = _t, date = _t, value = _t, #"product 1" = _t, product2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"name", type text}, {"date", type date}, {"value", Int64.Type}}),
    #"Grouped Rows"= Table.Group(Source, {"name"}, {{"most recent", each List.Max([date]), type date}, {"Column", each _, type table}}),
    #"Expanded Column" = Table.ExpandTableColumn(#"Grouped Rows", "Column", {"date", "product 1", "product2", "value"}, {"Column.date", "Column.product 1", "Column.product2", "Column.value"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Column", each [Column.date] = [most recent])
in
    #"Filtered Rows"
Regards,Lydia

bibra · Answer

'This does not work for me. I do have a question for this though:Where is it defined the data comes from another table?

anonymous · Answer

BiBra，I directly use Enter Data in Power BI Desktop to create a table. You can replace the source code with your own.If the above Power Query code doesn't work in your scenario, please post expected result based on the sample data you post.Regards,Lydia

Forum Discussion

Retrieving latest lata extent

3 Replies

Related content

Retrieve latest date

Retrieving data via HTML

Power BI API - Retrieving Latest Dataflow Refresh Status

Cannot retrieve Contacts from API

Retrieving deleted notebook