Forum Discussion

Lovebo01's avatar
Lovebo01
Helper I
5 years ago
Solved

Refer another table in query editor

Hello, I have a table with some date :

 

Table Orders

ValueDate Order
2017-07-2017
1223-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,

  • 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]))

     

     

2 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion

    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's avatar
      Lovebo01
      Helper I

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