Excel PowerPivot DAX Function & Features
CLOSINGBALANCEMONTH Function (DAX)
Syntax:
CLOSINGBALANCEMONTH(<expression>,<dates>,[<filter>])
Parameters:
expression: An expression that returns a scalar value.
dates: A column that contains dates.
filter: (optional) An expresion that specifies a filter to apply to the current context
Action:
Evaluates the expression at the lat date of the month in the current context.
Typo on URL: http://raj-excel.blogspot.nl/2016/09/excel-powerpivot-closingbalancemonth.html
ReplyDeleteTEXT
Action:
Evaluates the expression at the lat date of the month in the current context.
/TEXT
CORRECTION: the lat date = the la S t date