FOR vMonth = 0 to 11 MATMonthYear: LOAD [MonthYear], Date(AddMonths([MonthYear], $(vMonth)),'$(vMonthFormat)') as [MAT MonthYear] RESIDENT Sales WHERE AddMonths([MonthYear], $(vMonth)) < today() ; next
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.