Forum Discussion

zraopingm's avatar
zraopingm
Helper IV
2 years ago
Solved

switch with in dax

Hello Community,

can someone please tell me what is wrong with first image below? 

image 2 works fine

thank you

Zoey

 

 

 

Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    Try 

    FYQ = SWITCH(TRUE(), 'Date'[Month No] IN {7,8,9}, "Q4")

  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    Hi, 

    FYQ= SWITCH ( Date[Month No], 1, "Q1", 2, "Q1", 3, "Q1", 4, "Q2", 5, "Q2", 6, "Q2", 7, "Q3", 8, "Q3", 9, "Q3", 10, "Q4", 11, "Q4", 12, "Q4", "Unknown" )

     

    OR 

     

    FYQ= SWITCH ( TRUE(),

    Date[Month No]>=7 && Date[Month No]<=9, "Q3",

    Date[Month No]>=1 && Date[Month No]<=3, "Q1",

    Date[Month No]>=4 && Date[Month No]<=6, "Q2","Q4" )

4 Replies

  • jgeddes's avatar
    jgeddes
    Super User
    2 years ago

    Try 

    FYQ = SWITCH(TRUE(), 'Date'[Month No] IN {7,8,9}, "Q4")

  • Kaviraj11's avatar
    Kaviraj11
    Solution Sage
    2 years ago

    Hi, 

    FYQ= SWITCH ( Date[Month No], 1, "Q1", 2, "Q1", 3, "Q1", 4, "Q2", 5, "Q2", 6, "Q2", 7, "Q3", 8, "Q3", 9, "Q3", 10, "Q4", 11, "Q4", 12, "Q4", "Unknown" )

     

    OR 

     

    FYQ= SWITCH ( TRUE(),

    Date[Month No]>=7 && Date[Month No]<=9, "Q3",

    Date[Month No]>=1 && Date[Month No]<=3, "Q1",

    Date[Month No]>=4 && Date[Month No]<=6, "Q2","Q4" )