CLOSINGBALANCEMONTH DAX Function in Power BI

The CLOSINGBALANCEMONTH DAX function evaluates the expression at the last date of the month in the current context.

DAX Syntax CLOSINGBALANCEMONTH(expression, dates[, filter])

The function has the following parameters:

• Expression: An expression that returns a scalar value.
• Dates: A column that contains dates.
• Filter: It is an optional parameter. An expression that specifies a filter to apply to the current context.

Example: Let’s create a measure with name "CLOSINGBALANCEMONTH Measure".

DAX

The output of the above dax code is shown below:

Here the total 704 in the CLOSINGBALANCEMONTH Measure column, refers to the latest context i.e 14th August 1991.