BI-Annual Year Start and End

[Purushothaman]

Hi there,

Below are my measures for Quarter Start  and Annual Start. 

Quarter Start:

DATE(FLOOR(QUARTERSTART(DATE#(min({<Year_Offset={"0"},[Year Month_Offset]={"0"}>}[Year Month Base (YYYYMM)]),'YYYYMM'))),'YYYYMM')

Year Start:

DATE(FLOOR(YEARSTART(DATE#(min({<Year_Offset={"0"},[Year Month_Offset]={"0"}>}[Year Month Base (YYYYMM)]),'YYYYMM'))),'YYYYMM').

How to create the same for BI- Annual Start? I was using below, its not working properly. 

IF( (DATE(FLOOR(DATE#(min({<Year_Offset={"0"},[Year Month_Offset]={"0"}>}[Year Month Base (YYYYMM)]),'YYYYMM')),'MM'))<=6, LEFT([Year Month Base (YYYYMM)],4)&01,LEFT([Year Month Base (YYYYMM)],4)&07)

Anyone, Please help!!

Thank you!!

[brunobertels · Accepted solution]

Hi 

may be this :

IF( (num(DATE(FLOOR(DATE#(min({<Year_Offset={"0"},[Year Month_Offset]={"0"}>}[Year Month Base (YYYYMM)]),'YYYYMM')),'MM')))<=6, LEFT([Year Month Base (YYYYMM)],4)&01,LEFT([Year Month Base (YYYYMM)],4)&07)

or this 

IF( (month(DATE(FLOOR(DATE#(min({<Year_Offset={"0"},[Year Month_Offset]={"0"}>}[Year Month Base (YYYYMM)]),'YYYYMM')),'MM')))<=6, LEFT([Year Month Base (YYYYMM)],4)&01,LEFT([Year Month Base (YYYYMM)],4)&07)