[Power BI] DAX - GENERATE

 

Dates = 
VAR BaseCalendar =
    CALENDARAUTO(6)
RETURN
    GENERATE (
        BaseCalendar,
        VAR BaseDate = [Date]
        VAR YearDate = YEAR(BaseDate)
        VAR MonthNumber = MONTH(BaseDate)
        RETURN ROW("Day", BaseDate,
                    "Year", YearDate,
                    "Month Number", MonthNumber,
                    "Month", FORMAT(BaseDate, "mmmm"),
                    "Year Month", FORMAT(BaseDate, "mmm yy" )))