Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Solved! Go to Solution.
Follow @ziying35 's instruction:
Import AS_OF_DATE from the table or area into the query and name the query AS_OF_DATE
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
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)))
Follow @ziying35 's instruction:
Import AS_OF_DATE from the table or area into the query and name the query AS_OF_DATE
Thanks a lot .Its working fine.
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}))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.