Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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") ))
Solved! Go to Solution.
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"
)
@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"
)
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |