Forum Discussion

zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
2 years ago
Solved

switch with in Dax

Hello community 

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

thank you - Zoey

 

 

 

 

Need Help

2 Replies

  • Alex87's avatar
    Alex87
    Icon for Solution Sage rankSolution Sage
    2 years ago

    try this: 

    Measure =

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

  • MNedix's avatar
    MNedix
    Icon for Solution Sage rankSolution Sage
    2 years ago

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