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