yeartodate return true if date fall in the year of the date so if it is true (that is -1) multiply by -1 and have 1, if it is false (that is 0) you have 0
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
The same as previous but for previous year
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
returns true if date falls inside the year computed from Monthstart($(varMaxDate)),-1) that is the starting date of the month before the one indicated by the variable
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
this returns a string with the week of the date of weekstart and its year
This is calculates the values as true and false depends on the result YeartoDate returns the true and false according to the result it gives output as 1 and 0
YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
This calculates the previous year values as 1 and 0
inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
Returns true if date lies inside the year containing Monthstart($(varMaxDate)) and according to that multiples.
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
And this returns the Week of the weekstart(TempDate)
