CLOSINGBALANCEMONTH

CLOSINGBALANCEMONTH Evaluates the expression at the last date of the month in the current context.


Syntax

CLOSINGBALANCEMONTH(expression,dates[,filter])

Parameters

Expression – An expression that returns a scalar value.

Dates – A column that contains dates.

Filter – (optional) An expression that specifies a filter to apply to the current context.

Return Value

A scalar value that represents the expression evaluated at the last date of the month in the current context.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Time Intelligence Functions / CLOSINGBALANCEMONTH