DATESINPERIOD
The DATESINPERIOD function returns a set of dates starting from a certain day and covering n intervals of the indicated type backwards or forwards in time.
WEEKNUM
The WEEKNUM function returns the week number of the year to which the date passed as an argument belongs.
SUMMARIZE
The SUMMARIZE function returns a table aggregated based on a set of fields.
RELATEDTABLE
The RELATEDTABLE function returns the subset of a remote table related to the row being considered in the table in which we are working (current table), assuming that there is a relationship between the current table and the remote one, regardless of the type of relationship.
In other words, this function allows, for example, from a dimension table, to extract the associated records from a fact table in the form of a table.
RELATED
The RELATED function returns the value related to the row being considered from a column of another table (remote table), assuming that there is a relationship between the table in which you are working (current table) and the remote one, that this relationship is "many-to-one" or "one-to-one" type, and that the remote table is the one corresponding to the "one" side -that is, it is a dimension table-.
In other words, this function allows, from a table, to extract the field associated with each record in a related dimension table.
ISEMPTY
The ISEMPTY function checks if a table is empty, returning the logical value True if it is positive (if it is empty) and the logical value False if it is not.
ISNONTEXT
The ISNONTEXT function checks if a value is not of type text and returns the logical value True in positive case (if it is not of type text) and the logical value False in negative case (if it is of type text).
ISTEXT
The ISTEXT function checks if a value is of type text, returning the logical value True in positive case or the logical value False in negative case.
ISNUMBER
The ISNUMBER function checks whether a value is a number, returning the logical value True in positive case or the logical value False in negative case.
