How to filter a Table Column by values of an adjacent column

[Anonymous]

I have a table like this, with a Table type column.

I want to filter the content of each row of this Table Column using values from other columns of the same row of the main table. 


Specifically I want to use the values of FirstLogin to filter the content of the AddIndex tables,  using the column SessionStart.

I thought using Table.SelectRows but it seems that it doesn't differentiate well columns of the main table from the embedded-table.  

Table.SelectRows([AddIndex], each [SessionStart] > _[FirstLogin])

I would appreciate any idea. Thanks. 

[edhans · Accepted solution]

You need to use a variable @Anonymous 

See this example how to do this:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdFJCsQwDETRu3gdiEqOp2UPtwi5/zXigCWqGy20+dgPD+eZsGNXUUlbes1p6dqeqBbfc/qK2eJnDmTVw+qX9hdG64qVUVvZQrQz6nWwWlaEMOsV7HpVdr1mdofVg12vJTwvKsN2YbToGdDDAw+G/R8kchWRqz+f5jX/udcN", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Code = _t, Amount = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Amount", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Code"}, {{"MaxDate", each List.Max([Date]), type nullable date}, {"AllRows", each _, type table [Date=nullable date, Code=nullable text, Amount=nullable number]}}),
    #"Added Custom" = 
        Table.AddColumn(
            #"Grouped Rows", 
            "Max Value",
            each
                let
                    varDate = [MaxDate]
                in
                Table.SelectRows([AllRows], each [Date] = varDate)[Amount]{0})
in
    #"Added Custom"

How to use M code provided in a blank query:
1) In Power Query, select New Source, then Blank Query
2) On the Home ribbon, select "Advanced Editor" button
3) Remove everything you see, then paste the M code I've given you in that box.
4) Press Done
5) See this article if you need help using this M code in your model.