DAX Function Reference - Visual Intelligence - page 383

FuNCTIoN DESCrIPTIoN

FIRSTNONBLANK(< column >,
< expression >)

Returns the first value in the column
where the expression is not blank.

LASTDATE(< date_column >) Returns the last date in the current

context for the specified date column.

LASTNONBLANK (
< date_column >, < expression >)

Returns the last value in the column
where the expression is not blank.

NEXTDAY(< date_column >) Returns the next day date from

date_column .

NEXTMONTH(< date_column >) Returns the set of dates in the next

month from date_column .

NEXTQUARTER(< date_column >) Returns the set of dates for the next

quarter from date_column .

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

Returns the set of dates for the next
year from date_column .

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

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

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

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

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

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

PARALLELPERIOD(< dates >,
< number_of_intervals >,
< interval >)

Returns a table that contains a col-
umn 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.

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

umn of all dates representing the day
that is previous to the first date in the
dates column, in the current context.

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

umn of all dates from the previous
month, based on the first date in the
dates column, in the current context.

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

umn of all dates from the previous
quarter, based on the first date in the
dates column, in the current context.