I have created a DAX table using CALENDARAUTO But I dont want a date table with dates previous to what is in my data. I dont need dates from 1899. Is there any way I can have a date table that starts at say the start of your data set and ends at the end of the year of your data set?
Dim Date = VAR BaseCalendar = CALENDARAUTO(12)
RETURN GENERATE (
BaseCalendar,
VAR BaseDate = [DATE]
VAR YearDate = YEAR( BaseDate)
VAR MonthNumber = FORMAT(MONTH( BaseDate),"00")
VAR MonthName = FORMAT(DATE(1,MonthNumber,1),"MMMM")
VAR DayOfWeek = WEEKDAY(BaseDate)
VAR WeekDay = FORMAT(BaseDate,"DDDD")
VAR WeekNo = WEEKNUM(BaseDate)
VAR Quarter = ROUNDUP(Month(BaseDate)/3,0)
RETURN ROW (
"DateKey",YearDate&MonthNumber&FORMAT(DAY(BaseDate),"00"),
"Day", FORMAT(DAY(BaseDate),"00"),
"Year",YearDate,
"Quarter",Quarter,
"Month No", MonthNumber,
"Month",MonthName,
"Day of Week", DayOfWeek,
"Week Day",WeekDay,
"WeekNo", WeekNo
))
