Forum Discussion

4 Replies

  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi, create a column
    Term= If(Month('Calendar'[Date])>=4 && Month('Calendar'[Date])<=9, "KAMI" & Right(Year('Calendar'[Date]),2),
    If( Month('Calendar'[Date])>=10 || Month('Calendar'[Date])<=3 "SHIM"& Right(Year('Calendar'[Date]),2)))

    Appreciate your kudo and accepted solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi olgad ,

       

      Already try your method but its only show KAMI term only. Do you know why?

       

      if(SAP_SDT_LV_ISEG_EN[Month Only]>="04" && SAP_SDT_LV_ISEG_EN[Month Only]<="09", "KAMI" & Right(SAP_SDT_LV_ISEG_EN[Year Only],2) ,
      if(SAP_SDT_LV_ISEG_EN[Month Only]>="10" && SAP_SDT_LV_ISEG_EN[Month Only]<="03","SHIMO" & Right(SAP_SDT_LV_ISEG_EN[Year Only],2)))
       

       

       
      Regards,
      Nuha
  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Please adjust this part: instead of && it has to be ||. have tested and it works.

    if(SAP_SDT_LV_ISEG_EN[Month Only]>="10" || SAP_SDT_LV_ISEG_EN[Month Only]<="03","SHIMO" & Right(SAP_SDT_LV_ISEG_EN[Year Only],2)))

    Please kudo the solution and kindly accept it as resolved. Thank you!

  • olgad's avatar
    olgad
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Anonymous Have my answer solved your problem? If so, can you please accept my answer as Solution. Thank you very much for your kind cooperation!