DAX Function Reference - Visual Intelligence - page 384

FuNCTIoN DESCrIPTIoN

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

umn of all dates from the previous
year, given the last date in the dates
column, in the current context.

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

umn of dates shifted one year back in
time from the dates in the specified
dates column, in the current context.

STARTOFMONTH(< date_column >) Returns the first day of the month in

the specified date column.

STARTOFQUARTER(< date_column >) Returns the first day of the quarter in

the specified date column.

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

Returns the first day of the year in the
specified date column.

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

Evaluates the specified expression for
the interval that starts at the first day
of the month and ends at the latest
date in the specified dates column,
after applying all filters.

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

Evaluates the specified expression for
the interval that starts at the first day
of the quarter and ends at the latest
date in the specified dates column,
after applying all filters.

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

Evaluates the specified expression for
the interval that starts at the first day
of the year and ends at the latest date
in the specified dates column, after
applying all filters.