switch with in Dax

[zraopingm]

Hello community 

can someone please point out why the first formula does not work inmage1.. image 2 works fine.

thank you - Zoey

[MNedix · Accepted solution]

@zraopingm  use curly brackets instead of the rounded ones (e.g: {7,8,9} )

[Alex87]

try this: 

Measure =

SWITCH(
TRUE(),
'Date'[MonthNo] = 7 || 'Date'[MonthNo] = 8 || 'Date'[MonthNo] = 9, "Q4",
"Other Quarter" 
)