OPENINGBALANCEMONTH DAX Function in Power BI
The OPENINGBALANCEMONTH DAX function evaluates the expression at the first date of the month in the current context.
DAX Syntax OPENINGBALANCEMONTH(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. An expression that specifies a filter to apply to the current context.
Example: Let’s create a measure with name "OPENINGBALANCEMONTH Measure".
DAX
OPENINGBALANCEMONTH Measure = OPENINGBALANCEMONTH(SUM('Students List'[10th Marks]),'Students List'[Dates])
The output of the above dax code is shown below:
