Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query Editor - filter a query column based on another query column

I have the following situation: One Date table with that includes information until the last date included in the SQL. Google Analytics connection that includes Google Adwords Costs until the very ...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago
    = let max =MaxDate[MaxDate]{0} in Table.SelectRows(#"Changed Type", each [Date] <= max)
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago
= let max =MaxDate[MaxDate]{0} in Table.SelectRows(#"Changed Type", each [Date] <= max)
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you CNENFRNL !

    It worked.

     

    Full syntax used:

    let
    max =MaxDate[MaxDate]{0},
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("NcjBCQAgDAPAXfIWtLVWnEW6/xoiJPe8e5Hdug83NBiq/XBFMKZiMkKRjKVwRioOYys2qh4=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Value", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [Date] <= max)

    in
    #"Filtered Rows"