Stock max date in a variable

[Anonymous]

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

[Anonymous · Accepted solution]

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