Time Intelligence Functions

Question 1

OPENINGBALANCEMONTH(expression,dates[,filter])

Answer 1

Evaluates the expression at the first date of the month in the current context.

Question 2

OPENINGBALANCEQUARTER(expression,dates[,filter])

Answer 2

Evaluates the expression at the first date of the quarter, in the current context.

Question 3

OPENINGBALANCEYEAR(expression,dates[,filter][,year_end_date])

Answer 3

Evaluates the expression at the first date of the year in the current context.

Question 4

CLOSINGBALANCEMONTH(expression,dates[,filter])

Answer 4

Evaluates the expression at the last date of the month in the current context.

Question 5

CLOSINGBALANCEQUARTER(expression,dates[,filter])

Answer 5

Evaluates the expression at the last date of the quarter in the current context.

Question 6

CLOSINGBALANCEYEAR(expression,dates[,filter][,year_end_date])

Answer 6

Evaluates the expression at the last date of the year in the current context.

Question 7

TOTALQTD(expression,dates[,filter])

Answer 7

Evaluates the value of the expression for the dates in the quarter to date, in the current context.

Question 8

TOTALMTD(expression,dates[,filter])

Answer 8

Evaluates the value of the expression for the month to date, in the current context.

Question 9

TOTALYTD(expression,dates[,filter][,year_end_date])

Answer 9

Evaluates the year-to-date value of the expression in the current context.

Question 10

NEXTDAY(dates)

Answer 10

Returns a table that contains a column of all dates from the next day, based on the first date specified in the dates column in the current context.

Question 11

NEXTMONTH(dates)

Answer 11

Returns a table that contains a column of all dates from the next month, based on the first date in the dates column in the current context.

Question 12

PREVIOUSMONTH(Dates)

Answer 12

Returns a table that contains a column of all dates from the previous month, based on the first date in the Dates column, in the current context.

Question 13

PREVIOUSQUARTER(dates)

Answer 13

Returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context.

Question 14

PREVIOUSYEAR(dates[,year_end_date])

Answer 14

Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context.

Question 15

NEXTQUARTER(dates)

Answer 15

Returns a table that contains a column of all dates in the next quarter, based on the first date specified in the dates column, in the current context.

Question 16

NEXTYEAR(dates[,year_end_date])

Answer 16

Returns a table that contains a column of all dates in the next year, based on the first date in the dates column, in the current context.

Question 17

PREVIOUSDAY(dates)

Answer 17

Returns a table that contains a column of all dates representing the day that is previous to the first date in the dates column, in the current context.

Question 18

SAMEPERIODLASTYEAR(dates)

Answer 18

Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.

Question 19

DATESINPERIOD(dates, start_date, number_of_intervals, interval)

Answer 19

Returns a table that contains a column of dates that begins with a specified start date and continues for the specified number and type of date intervals.

Question 20

DATESBETWEEN(Dates, StartDate, EndDate)

Answer 20

Returns a table that contains a column of dates that begins with a specified start date and continues until a specified end date.

Question 21

PARALLELPERIOD(dates,number_of_intervals,interval)

Answer 21

Returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time.

Question 22

DATEADD(dates,number_of_intervals,interval)

Answer 22

Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context.

Question 23

DATESMTD(dates)

Answer 23

Returns a table that contains a column of the dates for the month to date, in the current context.

Question 24

DATESQTD(dates)

Answer 24

Returns a table that contains a column of the dates for the quarter to date, in the current context.

Question 25

DATESYTD(dates [,year_end_date])

Answer 25

Returns a table that contains a column of the dates for the year to date, in the current context.

Question 26

FIRSTDATE(dates)

Answer 26

Returns the first date in the current context for the specified column of dates.

Question 27

STARTOFMONTH(dates)

Answer 27

Returns the first date of the month in the current context for the specified column of dates.

Question 28

STARTOFQUARTER(dates)

Answer 28

Returns the first date of the quarter in the current context for the specified column of dates.

Question 29

STARTOFYEAR(dates)

Answer 29

Returns the first date of the year in the current context for the specified column of dates.

Question 30

FIRSTNONBLANK(column,expression)

Answer 30

Returns the first value in the column, column, filtered by the current context, where the expression is not blank.

Question 31

LASTDATE(dates)

Answer 31

Returns the last date in the current context for the specified column of dates.

Question 32

ENDOFMONTH(dates)

Answer 32

Returns the last date of the month in the current context for the specified column of dates.

Question 33

ENDOFQUARTER(dates)

Answer 33

Returns the last date of the quarter in the current context for the specified column of dates.

Question 34

ENDOFYEAR(dates [,year_end_date])

Answer 34

Returns the last date of the year in the current context for the specified column of dates.

Question 35

LASTNONBLANK(column,expression)

Answer 35

Returns the last value in the column, column, filtered by the current context, where the expression is not blank.