The fields QuarterIndex, MonthIndex and WeekIndex must be relative to the current date without considering the quarter, month or week. It will be more usefull in PBI.
Also consider to add DayIndex like:
DATEDIFF(day,GETDATE(),[DateValue])
SUBMITTED
Index Fields in Date dimension
+4
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
