calculating financial year quarters

[Anonymous]

Hi All

I am getting a error in caculating Quarters like this

Can you help me identify

FY Qtr = SWITCH(TRUE(),

MONTH(financials[Date].[Month])=1,"Q4",

MONTH(financials[Date].[Month])=3,"Q4",

MONTH(financials[Date].[Month])=3,"Q4",

MONTH(financials[Date].[Month])=4,"Q1",

MONTH(financials[Date].[Month])=5,"Q1",

MONTH(financials[Date].[Month])=6,"Q1",

MONTH(financials[Date].[Month])=7,"Q2",

MONTH(financials[Date].[Month])=8,"Q2",

MONTH(financials[Date].[Month])=9,"Q2",

MONTH(financials[Date].[Month])=10,"Q3",

MONTH(financials[Date].[Month])=11,"Q3",

MONTH(financials[Date].[Month])=12,"Q3",BLANK() )

Error says "Cannot convert December to type text to type date"

[v-cazheng-msft]

Hi @Anonymous 

Noticed that you have resolved your issue by yourself, right? Could you please mark your solution by Accept as solution to help the other members find it more quickly. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[Fowmy · Accepted solution]

@Anonymous 

You can create your Quarter Column as follows:

Quarter = 
VAR __M = MONTH ( financials[Date] )
RETURN

SWITCH(
    TRUE(),
    __M IN {1,2,3} , "Q4",
    __M IN {4,5,6} , "Q1",
    __M IN {7,8,9} , "Q2",
    __M IN {10,11,12} , "Q3"
)

[Anonymous]