Time intelligence

STARTOFYEAR is a DAX function that returns the first date of the year for a given date. Syntax Argument Properties Description Dates The name of a … Read More

STARTOFQUARTER is a DAX function that returns the first date of the quarter for a given date. Syntax Argument Properties Description Dates The name of a … Read More

TOTALYTD is a DAX function that evaluates an expression over the year-to-date period based on a specified date column and filters. Syntax Argument Properties Description Expression … Read More

STARTOFMONTH is a DAX function that returns the first date of the month for a given date. Syntax Argument Properties Description Dates The name of a … Read More

TOTALMTD is a DAX function that evaluates an expression over the month-to-date period based on a specified date column and filters. Syntax Argument Properties Description Expression … Read More

TOTALQTD is a DAX function that evaluates an expression over the quarter-to-date period based on a specified date column and filters. Syntax Argument Properties Description Expression … Read More

PREVIOUSYEAR is a DAX function that returns the date of the previous year. Syntax Argument Properties Description Dates The name of a column containing dates or … Read More

SAMEPERIODLASTYEAR is a DAX function that returns a set of dates from the previous year corresponding to the current selection. Syntax Argument Properties Description Dates The … Read More

PREVIOUSMONTH is a DAX function that returns the date of the previous month. Syntax Argument Properties Description Dates The name of a column containing dates or … Read More

PREVIOUSQUARTER is a DAX function that returns the date of the previous quarter. Syntax Argument Properties Description Dates The name of a column containing dates or … Read More