Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Merge Queries - Bring Latest Value only

I am trying to merge queries - brining in the tempoary support table into the Store List.  I am looking to only get the Latest Support Date vs brining all items over.  SEe below , I'd only bring over...
Need Help
PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi jcastr02 

Create a Black Table in Power Query
Open Advance Editor
Paste below code

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bczBDQAgCEPRXTiTYFEjzmLcfw25EZXry2/XIgA2iGkKTLRopc2XItP+o6+TAxXkbQvtxQmCVzQjeyiifQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Store #" = _t, #"Support Start Date" = _t]),
    #"Changed Type with Locale" = Table.TransformColumnTypes(Source, {{"Support Start Date", type date}}, "en-US"),
    #"Grouped Rows" = Table.Group(#"Changed Type with Locale", {"Store #"}, {{"Count", each List.Max([Support Start Date]), type nullable date}})
in
    #"Grouped Rows"

 

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS