Recall list value

[Anonymous]

I have a table which has dynamic date value column  having only one value( AS_OF_DATE - 04/30/2020 ) this should be recalled and filter the data in another table.

What is the best approach to recall this value in another table in Mquery.

I have created a list for AS_OF_DATE and recalled in te Mquery ,however its not working as expected. 

Here is the sampple code:

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns1", each ([PROCESS_DATE] = AS_OF_DATE))

[ziying35]

Hi,@Anonymous 

Import AS_OF_DATE from the table or area into the query and name the query AS_OF_DATE, then add a line of code as follows:

=Table.FirstValue(Source)

Then you can use that code you wrote to reference it normally in other queries

[Anonymous]

I am not familar with Mquery. Please advise.

Here is the condition applied after converting the as of date as table. But its throwing empty table.

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns1", each ([PROCESS_DATE] = Table.FirstValue(AS_OF_DATE)))

[lbendlin · Accepted solution]

Follow @ziying35 's instruction:

Import AS_OF_DATE from the table or area into the query and name the query AS_OF_DATE

[Anonymous]

Thanks a lot .Its working fine.

[lbendlin]

Use the query name as the source, specify the [AS_OF_DATE]  column, and the first row as {0}

Let's say the query is called "Current" 

#"Filtered Rows" = Table.SelectRows(#"Renamed Columns1", each ([PROCESS_DATE] = Current[AS_OF_DATE]{0}))