| http://www.w3.org/ns/prov#value | - The image I posted is a sample data set, where only a portion of the accounts (CPAccountID) have records on 3/2/2014, but I want the closing balance for the last day (or prior), so the accounts with records on 3/1/2014 will be excluded if use the following =Calculate(SUM([DeferredIncomeCP]),LASTDATE(DimDate[FullDate])).
|