Time intelligence

DATESBETWEEN is a DAX function that returns the dates between two given dates. Syntax Argument Properties Description Dates The name of a column containing dates … Read More

DATESINPERIOD is a DAX function that returns the dates from a given period. Syntax Argument Properties Description Dates The name of a column containing dates … Read More

CLOSINGBALANCEYEAR is a DAX function that evaluates a specified expression for the date corresponding to the end of the current year after applying specified filters. … Read More

DATEADD is a DAX function that moves a given set of dates by a specified interval. Syntax Argument Properties Description Dates The name of a … Read More

CLOSINGBALANCEQUARTER is a DAX function that evaluates a specified expression for the date corresponding to the end of the current quarter after applying specified filters. … Read More

CLOSINGBALANCEMONTH is a DAX function that evaluates a specified expression for the date corresponding to the end of the current month after applying specified filters. … Read More

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