Using GENERATE and ROW instead of ADDCOLUMNS in DAX

 https://www.youtube.com/watch?v=AieQMS6rGvM

https://www.sqlbi.com/articles/using-generate-and-row-instead-of-addcolumns-in-dax/ 

Preferred solution:

Calendar 5 =

VAR BaseCalendar =

    CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2018, 12, 31 ) )

RETURN

    GENERATE (

        BaseCalendar,

        VAR BaseDate = [Date]

        VAR YearDate = YEAR ( BaseDate )

        VAR MonthNumber = MONTH ( BaseDate )

        VAR MonthName = FORMAT ( BaseDate, "mmmm" )

        VAR YearMonthName = FORMAT ( BaseDate, "mmm yy" )

        VAR YearMonthNumber = YearDate * 12 + MonthNumber - 1

        RETURN ROW (

            "Day", BaseDate,

            "Year", YearDate,

            "Month Number", MonthNumber,

            "Month", MonthName,

            "Year Month Number", YearMonthNumber,

            "Year Month", YearMonthName

        )

    )