I have a fact table that holds the Bank Account Balance on a daily basis. I created a cube and included this Measure. I want to define the following aggregation for Bank Account Balance:
"Sum across Non-Time dimensions and Closing Period across Time Dimension"
I could use the formula
([Measures].[Account Balance],ClosingPeriod([Date].[Day],[Date].CurrentMember))
but then it will not work when we are in the middle of the month.
Does anyone know how to solve this issue?