Refer another table in query editor

[Lovebo01]

Hello, I have a table with some date :

Table Orders

Value	Date Order
20	17-07-2017
12	23-08-2020

I want to filter the date dynamically with another table where I have only one value :

Table StopDate

DateToStop

01-08-2017

So I want to change in the query editor :

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Date Order] <= #date(2017, 1, 8))

By something like :

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Date Order] <= #date('StopDate[DateToStop]))

How is it possible ?

Thank you for your help,

Lovebo,

[CNENFRNL · Accepted solution]

Hi, @Lovebo01 , the syntax is like this

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Date Order] <= StopDate[DateToStop]{0}))

or equally

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Date Order] <= StopDate{0}[DateToStop]))

[Lovebo01]

Thanks a lot, that's exactly what I expected !!