Filtering a table using the FILTER function using a column form another

[Anonymous]

Good afternoon,

I have a problem with filtering a temporary table made by using the UNION function with other columns.

I want to return the lowest value with a minimum value coming from another table.

I want something like this but then with working variables, I am also open to filter each temporary Column but i'm unable to select the waiting column from the events table although that data is from the same table.

Thank you in advance for helping, if something is not clear i would be pleased to try to explain it but my english isn't the best.

[PaulDBrown · Accepted solution]

Wow! I lost count on the number of UNIONs in the variable

I would suggest you create the temp table in Power Query and take it from there,,,,