This functions provides native support for doing balances, e.g. for onhand inventory or general ledger balances. CloseBal returns the closing balance – which is the sum of the measure since beginning of time including "todays" transactions. Compared to CLOSEBAL, CLOSEBALWITHZEROES will add additional rows to the rowset if there are missing entries derived from the date being used.
Syntax:
SUM(CLOSEBALWITHZEROES(measure,[DateColumnName]))


  • No labels