Changing Quarter Name [Qtr1] to Q1 in DateDimension

[Anonymous]

Hi All,

 I need to change the Quarter Name [Qtr1] to Q1, Qtr2 to Q2 in DateDimension which is autopopulated Column in Date Hierarchy.

 Could you please share possible solutions to achieve it.

Regards,

Samrat

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

The quarter name can't be changed directly. You could create calculated columns and then create a new hierarchy to implement it.

Quarter = SWITCH(MONTH([Column1]),
                1,"Q1",2,"Q1",3,"Q1",
                4,"Q2",6,"Q2",6,"Q2",
                7,"Q3",8,"Q4",9,"Q4",
                10,"Q4",11,"Q4","Q4") 
Year = YEAR('Table (3)'[Column1])
Month = MONTH('Table (3)'[Column1])
Day = DAY('Table (3)'[Column1])

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.