Forum Discussion
Calendar Fiscal Quarter Offset M Code for Function
Hi Community! I have a calendar function and I need to work out how to get the Fiscal Quarter Offset. I understand I need the current date to extract the current fiscal year but I can't work out ...
Anonymous I used this
FY Quaters =
SWITCH(true(),
'Dates qtr'[Month Number] = 1, "Q3",
'Dates qtr'[Month Number] = 2, "Q3",
'Dates qtr'[Month Number] = 3, "Q3",
'Dates qtr'[Month Number] = 4, "Q4",
'Dates qtr'[Month Number] = 5, "Q4",
'Dates qtr'[Month Number] = 6, "Q4",
'Dates qtr'[Month Number] = 7, "Q1",
'Dates qtr'[Month Number] = 8, "Q1",
'Dates qtr'[Month Number] = 9, "Q1",
'Dates qtr'[Month Number] = 10, "Q2",
'Dates qtr'[Month Number] = 11, "Q2",
'Dates qtr'[Month Number] = 12, "Q2",
BLANK()
)