- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
CLOSINGBALANCEYEAR function
Description
Evaluates the expression at the last date of the year in the current context.
Syntax
CLOSINGBALANCEYEAR (<expression>, <dates>, [<filter>], [<year_end_date>])
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
expression An expression that returns a scalar value. |
| 2 |
dates A column that contains dates. |
| 3 |
filter Optional. An expression that specifies a filter to apply to the current context. |
| 4 |
year_end_date Optional. A literal string with a date that defines the year end date. The default is December 31. |
Return Value
A scalar value.
Remarks
The dates parameter 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.
Constraints on Boolean expressions −
The expression cannot reference a calculated field.
The expression cannot use CALCULATE function.
The expression cannot use any function that scans a table or returns a table, including aggregation functions.
However, a Boolean expression can use any function that looks up a single value, or that calculates a scalar value.
The filter parameter can be a Boolean expression or a table expression that defines a filter.
The year_end_date parameter is a string literal of a date, in the locale where the workbook was created. The year portion of the date is ignored.
Example
Year End Inventory Value:= CLOSINGBALANCEYEAR ( SUMX (ProductInventory, [UnitsBalance]*[UnitCost]),ProductInventory[InventoryDate] )