Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Recall list value

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

lbendlin
6 years ago
Follow ziying35 's instruction:

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

5 Replies

ziying35
Impactful Individual
6 years ago
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
  Not applicable
  6 years ago
  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
    Super User
    6 years ago
    Follow ziying35 's instruction:
    
    Import AS_OF_DATE from the table or area into the query and name the query AS_OF_DATE
lbendlin
Super User
6 years ago
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}))