Forum Discussion
Stock max date in a variable
Hello everyone,
I am creating my AAS cube.
I have 20 dimension tables.
To import each table, I do a select * from source table name where load date in (select Max(load date) from source table name)
I want to know if there is a method to store the Max(load date) from source table name in a separate variable in order to use it in each request to optimize performance, instead of creating the max in the 20 querys for the 20 dimension tables.
Thank you
It's easy. For whichever table you are getting the max date, add a new blank query, and use the formula:
= List.Max(SourceTable[DateColumn])
This will give you a value that you can use right in your SQL queries, so if this query we just made is named MaxDate, the the SQL is:
[Query = "Select...Where DateColumn <= "&MaxDate&"and ID = whatever"]
--Nate
1 Reply
It's easy. For whichever table you are getting the max date, add a new blank query, and use the formula:
= List.Max(SourceTable[DateColumn])
This will give you a value that you can use right in your SQL queries, so if this query we just made is named MaxDate, the the SQL is:
[Query = "Select...Where DateColumn <= "&MaxDate&"and ID = whatever"]
--Nate