Calendar

CalendarTable = CALENDARAUTO(3)

Year = YEAR(CalendarTable[Date])

Quater = "Q"& QUARTER(CalendarTable[Date])

Month = FORMAT(CalendarTable[Date],"MMM")

MonthNumber = MONTH(CalendarTable[Date])

Day = DAY(CalendarTable[Date])

FiscalYear = IF(MONTH(CalendarTable[Date]) >= 4, YEAR(CalendarTable[Date]), YEAR(CalendarTable[Date]) - 1)

FiscalQuarter =

    "Q" &

    SWITCH(

        TRUE(),

        MONTH(CalendarTable[Date]) IN {4, 5, 6}, 1,

        MONTH(CalendarTable[Date]) IN {7, 8, 9}, 2,

        MONTH(CalendarTable[Date]) IN {10, 11, 12}, 3,

        MONTH(CalendarTable[Date]) IN {1, 2, 3}, 4

    )

FiscalMonth =

    SWITCH(

        TRUE(),

        MONTH(CalendarTable[Date]) >= 4, MONTH(CalendarTable[Date]) - 3,

        MONTH(CalendarTable[Date]) + 9

    )

FiscalMonthName =

       SWITCH(

           CalendarTable[FiscalMonth],

           1, "Apr",

           2, "May",

           3, "Jun",

           4, "Jul",

           5, "Aug",

           6, "Sep",

           7, "Oct",

           8, "Nov",

           9, "Dec",

           10, "Jan",

           11, "Feb",

           12, "Mar"

       )