Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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] ) )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |