| Function<\/th> | Description<\/th><\/tr><\/thead> |
|---|---|
| CLOSINGBALANCEMONTH<\/td> | It is used to evaluate the expression at the last date of the month in the current context.<\/td><\/tr> |
| CLOSINGBALANCEQUARTER<\/td> | It is used to evaluate the expression at the last date of the quarter in the current context.<\/td><\/tr> |
| CLOSINGBALANCEYEAR<\/td> | It is used to evaluate the expression at the last date of the year in the current context.<\/td><\/tr> |
| DATEADD<\/td> | It is used to return 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.<\/td><\/tr> |
| DATESBETWEEN<\/td> | It returns a table that contains a column of dates that begins with a specified start date and continues until specified end date.<\/td><\/tr> |
| DATESINPERIOD<\/td> | It 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.<\/td><\/tr> |
| DATESMTD<\/td> | It returns a table that contains a column of the dates for the month to date, in the current context.<\/td><\/tr> |
| DATESQTD<\/td> | It returns a table that contains a column of the dates for the quarter to date, in the current context.<\/td><\/tr> |
| DATESYTD<\/td> | It returns a table that contains a column of the dates for the year to date, in the current context.<\/td><\/tr> |
| ENDOFMONTH<\/td> | It returns the last date of the month in the current context for the specified column of dates.<\/td><\/tr> |
| ENDOFQUARTER<\/td> | It returns the last date of the quarter in the current context for the specified column of dates.<\/td><\/tr> |
| ENDOFYEAR<\/td> | It returns the last date of the year in the current context for the specified column of dates.<\/td><\/tr> |
| FIRSTDATE<\/td> | It returns the first date in the current context for the specified column of dates.<\/td><\/tr> |
| FIRSTNONBLANK<\/td> | It returns the first value in the column, column, filtered by the current context, where the expression is not blank<\/td><\/tr> |
| LASTDATE<\/td> | It returns the last date in the current context for the specified column of dates.<\/td><\/tr> |
| LASTNONBLANK<\/td> | It returns the last value in the column, column, filtered by the current context, where the expression is not blank.<\/td><\/tr> |
| NEXTDAY<\/td> | It 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.<\/td><\/tr> |
| NEXTMONTH<\/td> | It 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.<\/td><\/tr> |
| NEXTQUARTER<\/td> | It 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.<\/td><\/tr> |
| NEXTYEAR<\/td> | It 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.<\/td><\/tr> |
| OPENINGBALANCEMONTH<\/td> | It is used to evaluate the expression at the first date of the month in the current context.<\/td><\/tr> |
| OPENINGBALANCEQUARTER<\/td> | It is used to evaluate the expression at the first date of the quarter, in the current context.<\/td><\/tr> |
| OPENINGBALANCEYEAR<\/td> | It is used to evaluate the expression at the first date of the year in the current context.<\/td><\/tr> |
| PARALLELPERIOD<\/td> | It 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.<\/td><\/tr> |
| PREVIOUSDAY<\/td> | It 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.<\/td><\/tr> |
| PREVIOUSMONTH<\/td> | It 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.<\/td><\/tr> |
| PREVIOUSQUARTER<\/td> | It 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.<\/td><\/tr> |
| PREVIOUSYEAR<\/td> | It 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.<\/td><\/tr> |
| SAMEPERIODLASTYEAR<\/td> | It 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.<\/td><\/tr> |
| STARTOFMONTH<\/td> | It returns the first date of the month in the current context for the specified column of dates.<\/td><\/tr> |
| STARTOFQUARTER<\/td> | It returns the first date of the quarter in the current context for the specified column of dates.<\/td><\/tr> |
| STARTOFYEAR<\/td> | It returns the first date of the year in the current context for the specified column of dates.<\/td><\/tr> |
| TOTALMTD<\/td> | It is used to evaluate the value of the expression for the month to date, in the current context.<\/td><\/tr> |
| TOTALQTD<\/td> | It is used to evaluate the value of the expression for the dates in the quarter to date, in the current context.<\/td><\/tr> |
| TOTALYTD<\/td> | It is used to evaluate the year-to-date value of the expression in the current context.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Learn more about Time Intelligence Functions<\/a><\/p>\n\n\n\n |
![\"Microsoft](\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\")
<\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"