Power Query - filter Table Cell using Outer Reference

[jvmorren]

I need to filter a table cell using an outer reference

= Table.AddColumn(#"Added Custom1", "Custom.2", each Table.SelectRows([Custom.1],each ([ChildInvoiceDate]=Date.AddDays(#"Added Custom1"[InvoiceDate],-365))))

In other words, [Custom.1] is a Cell which contains a table.  I need to filter "ChildInvoiceDate" using the parent InvoiceDate i.e. another column cell on the main table.

[LivioLanzo]

@jvmorren

you can try by creating a simple function

fn = ( InvDate as date, T as table ) => Table.SelectRows( T, each [ChildInvoiceDate] = Date.AddDays( InvDate, -365 ) )


AddCol = Table.AddColumn(
		#"Added Custom1", 
		"Custom.2", 
		each fn( [InvoiceDate], [Custom.1] )
         )