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 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...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

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

     

     

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

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
5 years ago

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