OPENINGBALANCEWEEK

Applies to: Calculated column Calculated table Measure Visual calculation

Note

This function is discouraged for use in visual calculations as it likely returns meaningless results.

Evaluates the expression at the date corresponding to the end of the previous week in the current context.

Note

Week functions only work with calendar based time intelligence.

Syntax

OPENINGBALANCEWEEK(<expression>,<calendar>[,<filter>])

Parameters

Term	Definition
expression	An expression that returns a scalar value.
calendar	A calendar reference.
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 end of the previous week in the current context.

Remarks

• Constraints on Boolean expressions are described in the topic, CALCULATE function.

• The filter expression has restrictions described in the topic, CALCULATE function.

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example for calendar based time intelligence

The following sample formula creates a measure that calculates the 'Week Start Inventory Value' of the product inventory in terms of fiscal calendar.

=
OPENINGBALANCEWEEK (
    SUMX (
        ProductInventory,
        ProductInventory[UnitCost] * ProductInventory[UnitsBalance]
    ),
    FiscalCalendar
)

Related content

OPENINGBALANCEYEAR function OPENINGBALANCEQUARTER function OPENINGBALANCEMONTH function Time intelligence functions CLOSINGBALANCEWEEK function