selectMaxDate

Returns the max value (Date, Timestamp, or Datetime) from the specified table column.

This function serves as a manual substitute for the Now() and CurrentTimestamp() functions. It provides a way to manually control the dynamic expression key member by inserting or updating the table at the end of a periodic ETL batch job. In this way, you can have explicit control over the high-water mark used in the model without relying on the point-in-time return value of Now() or CurrentTimestamp().

This function can be used to avoid exposing users to partially populated sets of tables. Additionally, it may be useful for models that rely on non-Gregorian values of Now(), as these models cannot use the Now() function to identify the current non-Gregorian Date key.

[Order Date Dimension].[Order Date Month Hierarchy].[Day].&[`selectMaxDate("myschema.etl_high_watermark", "data_load_complete_date")`]