.png)
CLOSINGBALANCEYEAR Function (DAX)
Evaluates the expression at the last date of the year in the current context.
Parameter | Definition |
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. |
year_end_date | (optional) A literal string with a date that defines the year-end date. The default is December 31. |
 Note |
|---|
To understand more about how context affects the results of formulas, see Context in DAX Formulas. |
The dates argument can be any of the following:
A reference to a date/time column.
A table expression that returns a single column of date/time values.
A Boolean expression that defines a single-column table of date/time values.
| Note |
|---|
Constraints on Boolean expressions are described in the topic, CALCULATE Function (DAX). |
| Note |
|---|
The filter expression has the restrictions described in the topic, CALCULATE Function (DAX). |
The year_end_date parameter is a string literal of a date, in the same locale as the locale of the client where the workbook was created. The year portion of the date is ignored.
Example
The following sample formula creates a measure that calculates the 'Year End Inventory Value' of the product inventory.
To see how this works, create a PivotTable and add the field, CalendarYear, to the Row Labels area of the PivotTable. Then add a measure, named Year End Inventory Value, using the formula defined in the code section, to the Values area of the PivotTable.
Code
=CLOSINGBALANCEYEAR(SUMX(ProductInventory,ProductInventory[UnitCost]*ProductInventory[UnitsBalance]),DateTime[DateKey])
