Time intelligence

PARALLELPERIOD is a DAX function that returns a parallel period of dates based on a given set of dates and a specified interval. Syntax Argument Properties … Read More

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

OPENINGBALANCEQUARTER is a DAX function that evaluates an expression for the date corresponding to the end of the previous quarter after applying specified filters. Syntax Argument … Read More

OPENINGBALANCEYEAR is a DAX function that evaluates an expression for the date corresponding to the end of the previous year after applying specified filters. Syntax Argument … Read More

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

OPENINGBALANCEMONTH is a DAX function that evaluates an expression for the date corresponding to the end of the previous month after applying specified filters. Syntax Argument … Read More

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

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

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

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