Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Lovebo01
Helper I
Helper I

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,

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
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]))

 

 


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

2 REPLIES 2
CNENFRNL
Community Champion
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]))

 

 


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.