The Syntax ',' is incorrect

Hi M_SBS_6 ,

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.

M_SBS_6 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"
)