I am trying to do an Actual Till Date analysis from a given selected month.

For eg. If the balance_sheet starts on 1 april 2005, I would like to know the actual balance from April 2005 to October 2005.

Time are a dimension and is organised as Year->Month
Balance_Sheet is my fact table and Measure.balance gives me the balance of the selected month.

I presume PeriodToDate is what will solve my problem, but how do I use it?

Any help would be greatly appreciated!