How to name a term for every 6 month

[Anonymous]

Hi all,

Do you have any idea or formulation how to set a term name for every 6 month. Please refer below as example.

The term name keep going every 6 month.

Regards,

Nuha

[olgad]

@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!

[olgad]

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]

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]

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