Time intelligence

LASTDATE is a DAX function that returns the last non-blank date in a column. Syntax Argument Properties Description Dates The name of a column containing dates … Read More

LASTNONBLANK is a DAX function that returns the last value in a column for which an expression is non-blank. Syntax Argument Properties Description ColumnName The source … Read More

FIRSTNONBLANK is a DAX function that returns the first value in a column for which an expression is non-blank. Syntax Argument Properties Description ColumnName The source … Read More

FIRSTNONBLANKVALUE is a DAX function that returns the first non-blank value of an expression evaluated for a column. Syntax Argument Properties Description ColumnName The source values. … Read More

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

FIRSTDATE is a DAX function that returns the first non-blank date in a column. Syntax Argument Properties Description Dates The name of a column containing dates … Read More

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

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

DATESMTD is a DAX function that returns a set of dates in the month up to the current date. Syntax Argument Properties Description Dates The … Read More

DATESQTD is a DAX function that returns a set of dates in the quarter up to the current date. Syntax Argument Properties Description Dates The … Read More