Power BI | DAX Date Table

dax

_Date = 
VAR BaseCalendar = CALENDARAUTO()
RETURN
    GENERATE (
        BaseCalendar,
        VAR BaseDate = [Date]
        VAR DayNumber = Right(CONCATENATE("00",DAY ( BaseDate )),2)
        VAR YearDate = YEAR ( BaseDate )
        VAR MonthNumber = Right(CONCATENATE("00",MONTH ( BaseDate )),2)
        VAR JoinDate = CONCATENATE(01,CONCATENATE("/",CONCATENATE(MonthNumber,CONCATENATE("/",2018))))
        VAR MonthName = FORMAT ( BaseDate, "mmm")
        VAR MonthFullName = FORMAT ( BaseDate, "mmmm")
        VAR YearMonthName = FORMAT ( BaseDate, "yyyymmmm" )
        VAR YearMonthNumber = YearDate * 12 + MonthNumber - 1
        VAR Aging = TODAY() - BaseDate
        RETURN ROW (
            "Join Date",JoinDate,
            "Day", DayNumber,
            "Year", YearDate,
            "Month Number", MonthNumber,
            "Month", MonthName,
            "Month Full", MonthFullName,
            "Year Month Number", YearMonthNumber,
            "Year Month", YearMonthName,
            "Aging", Aging
        )
    )