EXACT
The EXACT function compares two text strings, returning True if they are the same and False otherwise.
BLANK
The BLANK function returns an empty value.
CONCATENATE
The CONCATENATE function joins two text strings into one.
REPLACE
The REPLACE function replaces a part of a text string with another text string, given an initial position from which the replacement is desired, a number of characters to replace and the text string with which you want to replace the referred characters.
TIME
The TIME function returns a time in datetime format.
WEEKDAY
The WEEKDAY function receives a date as an argument and returns a number identifying the day of the week to which it corresponds (from Monday to Sunday).
CALENDAR
The CALENDAR function returns a table with a single column named "Date" containing a sequential range of dates between two dates given as arguments (and included in the range).
CALENDARAUTO
The CALENDARAUTO function returns a table with a single column named "Date" containing a sequential range of dates between two dates automatically extracted from the data model (and included in the range).
DATEDIFF
The DATEDIFF function returns the difference in the specified scale between two dates.
TODAY
The TODAY function returns the current date in datetime format. The time returned by this function is always 00:00:00. This function is useful for making calculations that depend on the number of days elapsed or the number of days that will elapse until a certain event.
