Measure to Calculate YTD does not work if when a new month is selected

[Mavericks334]

Hi,

I have a measure that calculates the YTD values. I have a filter that allows a person to select the month. Based on the filter the YTD values get updated.

When my filter is on the 1st month. The Monthly and YTD Values are the same. When i select the second month instead of adding both the 1st and 2nd month together it is adding some other values and giving me an incorrect value.

Below is the measure that i have written.

YTD: Cascade_YTD_Tickets: =CALCULATE([Total_Ticket_Queued],DATESBETWEEN(Dates[Dates],DATEADD(LASTDATE(Year_Period[Next_Month_Start_Date]),MAX(Year_Period[Calendar_Period])*-1,MONTH),LASTDATE(Year_Period[Month_End_Date]))) /CODE].

Regards,
Ren.

 

[Mavericks334]

When i use this measure

=CALCULATE([Total_Ticket_Queued],DATESBETWEEN(Dates[Dates],DATEADD(LASTDATE(Year_Period[Month_Start_Date]),[Selected_Calendar_Period]*-1,MONTH),[Selected_Month_End_Date]))

It addes the previous two months. One which is of the previous year

It should add Jan and Feb. However it is adding Dec+Jan+Feb. Any Suggestions what needs to be changed.