cancel
Showing results for
Did you mean:
Helper II

## The Syntax ',' is incorrect

Hi, I am trying to create a new Quarter column based on the following log below, but seem to be getting the incorrect syntax to enbale this to work. I have tried mutliple things, but just can't work out how to resolve.

quarter_financial_years = VAR __M = MONTH ( comp[comp_date] )
RETURN

if(isblank(comp[comp_date]), blank(),

if(comp[comp_fy_start_month_no] = 7,
__M IN {7,8,9} , "Q1",
__M IN {10,11,12} ,"Q2",
__M IN {1,2,3} , "Q3",
__M IN {4,5,6} , "Q4"),

if(comp[comp_fy_start_month_no] = 4,
__M IN {4,5,6} , "Q1",
__M IN {7,8,9} , "Q2",
__M IN {10,11,12} , "Q3",
__M IN {1,2,3} , "Q4"),

if(comp[comp_fy_start_month_no] = 10
__M IN {10,11,12} , "Q1",
__M IN {1,2,3} , "Q2",
__M IN {4,5,6} , "Q3",
__M IN {7,8,9} , "Q4") ))

2 ACCEPTED SOLUTIONS
Solution Sage

Hi @EML_7 ,

delete these 2 commas

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

Super User

@EML_7 Try:

``````quarter_financial_years =
VAR __M = MONTH ( comp[comp_date] )
RETURN
SWITCH(TRUE(),
isblank(comp[comp_date]), blank(),
comp[comp_fy_start_month_no] = 7 && __M IN {7,8,9} , "Q1",
comp[comp_fy_start_month_no] = 7 && __M IN {10,11,12} ,"Q2",
comp[comp_fy_start_month_no] = 7 && __M IN {1,2,3} , "Q3",
comp[comp_fy_start_month_no] = 7 && __M IN {4,5,6} , "Q4"),

comp[comp_fy_start_month_no] = 4 && __M IN {4,5,6} , "Q1",
comp[comp_fy_start_month_no] = 4 && __M IN {7,8,9} , "Q2",
comp[comp_fy_start_month_no] = 4 && __M IN {10,11,12} , "Q3",
comp[comp_fy_start_month_no] = 4 && __M IN {1,2,3} , "Q4"),

comp[comp_fy_start_month_no] = 10 && __M IN {10,11,12} , "Q1",
comp[comp_fy_start_month_no] = 10 && __M IN {1,2,3} , "Q2",
comp[comp_fy_start_month_no] = 10 && __M IN {4,5,6} , "Q3",
comp[comp_fy_start_month_no] = 10 && __M IN {7,8,9} , "Q4"
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
Super User

@EML_7 Try:

``````quarter_financial_years =
VAR __M = MONTH ( comp[comp_date] )
RETURN
SWITCH(TRUE(),
isblank(comp[comp_date]), blank(),
comp[comp_fy_start_month_no] = 7 && __M IN {7,8,9} , "Q1",
comp[comp_fy_start_month_no] = 7 && __M IN {10,11,12} ,"Q2",
comp[comp_fy_start_month_no] = 7 && __M IN {1,2,3} , "Q3",
comp[comp_fy_start_month_no] = 7 && __M IN {4,5,6} , "Q4"),

comp[comp_fy_start_month_no] = 4 && __M IN {4,5,6} , "Q1",
comp[comp_fy_start_month_no] = 4 && __M IN {7,8,9} , "Q2",
comp[comp_fy_start_month_no] = 4 && __M IN {10,11,12} , "Q3",
comp[comp_fy_start_month_no] = 4 && __M IN {1,2,3} , "Q4"),

comp[comp_fy_start_month_no] = 10 && __M IN {10,11,12} , "Q1",
comp[comp_fy_start_month_no] = 10 && __M IN {1,2,3} , "Q2",
comp[comp_fy_start_month_no] = 10 && __M IN {4,5,6} , "Q3",
comp[comp_fy_start_month_no] = 10 && __M IN {7,8,9} , "Q4"
)``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Solution Sage

Hi @EML_7 ,

delete these 2 commas

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