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]
)
dax_functions_time_intelligence.htm
Advertisements