OPENINGBALANCEQUARTER DAX Function in Power BI
The OPENINGBALANCEQUARTER DAX function evaluates the expression at the first date of the quarter, in the current context.
DAX Syntax OPENINGBALANCEQUARTER(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. It specifies an expression that specifies a filter to apply to the current context.
Example: Create a measure with name “OPENINGBALANCEQUARTER Measure”.
DAX
OPENINGBALANCEQUARTER Measure = OPENINGBALANCEQUARTER(SUM('Students List'[10th Marks]),'Students List'[Dates])
The output of the above dax code is shown below:
