Month Year in Hirarchy

[Anonymous]

Hello Expert,
1st step to create calendar using below mentioned scripts . which will give hirachy also

Table2 = CALENDAR(DATE(2016,1,1),DATE(2019,12,31))

2nd step create a column 
Format('Table 3'[Date],"MMM-YY")

and add month- year column in hirarchy or tell me the alternate step where we can add month-year column in hirarchy

Shree

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

You could add date column in a table or matrix visual, then select "date hierarchy".

if you want the month to display as "MMM-YY" format, you could create the table as below

Table2 =
ADDCOLUMNS (
    CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2019, 12, 31 ) ),
    "year", YEAR ( [Date] ),
    "month", MONTH ( [Date] ),
    "day", DAY ( [Date] ),
    "MMM-YY", FORMAT ( [Date], "MMM-YY" ),
    "quarter", SWITCH (
        TRUE (),
        MONTH ( [Date] ) <= 3, "Qtr 1",
        MONTH ( [Date] ) <= 6, "Qtr 2",
        MONTH ( [Date] ) <= 9, "Qtr 3",
        MONTH ( [Date] ) <= 12, "Qtr 4"
    )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Please check if this can help

https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/