Thanks Thomas.. am very grateful Thanks Gianni . noted and well said.

you could have 12/31/2016 as both a day row and a month end row and a year end row I get 12/31/2016 as end of month row already.

Yes I can do that, in my date dimension I have ISENDOFMONTH flag. Now I need how to manipulate the function to sum the amount up to make YTD. I want to be able to do: 1. Jan to August (all end of month) M + M + M + M + M + M + M + M 2. Jan to August (Non end of month) M + M + M + M + M + M + M +D This should work for any…