Try to debug this by splitting query: E

Try to debug this by splitting query: Execute: SELECT {YTD([Date].[Year].CurrentMember)} ON 0 , {[Measures].[NRT Count]} ON 1 FROM [Data Warehouse] Do you see expected results. If no, replace YTD with PeriodsToDate and specify proper level. If PeriodsToDate works, your date dimension does not have proper "Type" property set.