Forum Discussion
Lovebo01
5 years agoHelper I
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 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
- Lovebo01Helper I
Thanks a lot, that's exactly what I expected !!