DAX Function Reference - Visual Intelligence - page 382

FuNCTIoN DESCrIPTIoN

CLOSINGBALANCEQUARTER(
< expression >, < dates >,
< filter >)

Evaluates the specified expression at
the calendar end of the given quarter.
The given quarter is calculated as the
quarter of the latest date in the dates
argument, after applying all filters.

CLOSINGBALANCEYEAR(
< expression >, < dates >,
< filter >)

Evaluates the specified expression at
the calendar end of the given year.
The given year is calculated as the
year of the latest date in the dates
argument, after applying all filters.

DATEADD(< date_column >,
< number_of_intervals >,
< interval >)

Returns a table that contains a col-
umn of dates, shifted either forward
in time or back in time from the dates
in the specified date column.

DATESBETWEEN(< column >,
< start_date >, < end_date >

Returns a table of dates that can be
found in the specified date column
beginning with the start date and
ending with the end date.

DATESINPERIOD(< date_column >,
< start_date >,
< number_of_intervals >,
< intervals >)

Returns a table of dates that can be
found in the specified date column
beginning with the start date and
continuing for the specified number
of intervals.

DATESMTD(< dates >) Returns a table that contains a col-

umn of the dates for the month to
date.

DATESQTD(< date_column >) Returns a table that contains a col-

umn of the dates for the quarter to
date.

DATESYTD(< date_column > [,
< YE_date >])

Returns a table that contains a col-
umn of the dates for the year to date.
The year_end_date (optional) is a
literal string with a date that defines
the year-end date. The default is
December 31.

ENDOFMONTH(< date_column >) Returns the last day of the month in

the specified date column.

ENDOFQUARTER(< date_column >) Returns the last day of the quarter in

the specified date column.

ENDOFYEAR(< date_column >) Returns the last day of the year in the

specified date column.

FIRSTDATE(< date_column >) Returns the first date in the current

context for the specified date column.