PowerQuery - filtering a Table by externaal column

[Radoslaw Poprawski]

Hello,
I have a PQ Table with A column containing Table and a column with currency adjacent to it.

Now I want to filter that Table within Table by that adjacent column.

I know how to Partially make this work:

= Table.TransformColumns(CurrencySplitToRows, {"Final Table Data", each Table.SelectRows(_, each [#"Currency(ISO format)"] = "EUR" ) })

However im having big problem adjusting this M code to be more dynamic:

I would like to filter my Table in "Final Table Data" Column [#"Currency(ISO format)"] to external [Currency] column


Any idea how?

 

[Radoslaw Poprawski]

up by one