Split the year into six monthly periods

[Anonymous]

HI All,

I have a dataset in Power BI in this format. 

Besides table does NOT have any date field.

So, I can use same method to extract the Year following this link
CONCATENATE, YEAR, MONTH and  DATEVALUE DAX functions to achieve  this.


However, I need to extract 1st Half (Jan - June) and 2nd Half (July - Dec) for that specific year such as 2015, 2016, 2017 etc.

I found some amazing blog to extract Week, Month, and Quarter. But I need six monthly function.
Any inputs will be highly appreciated.

Thanks in advance.     

[SivaMani]

It will be helpful to assist if you share some sample data.

[Anonymous]

@SivaMani ..Thanks for your reply.

Here is part of sample data ..

[SivaMani]

Correct me if I'm wrong.

Your requirement is,

if the value has 1st half then you wanted to have it Jan - Jun. Right?

For example,

2nd H1 FY2017 will be Jul - Dec

[Anonymous]

@SivaMani Excatly! 

There will be 2 columns for user so that can report

1. Specific Year,  (Date Format), 2017  ( from the dataset 2nd H1 FY2017)  - I already did that part
2. Specific period, (Text), an indicator that its 2nd H1 for 2017.  

[SivaMani · Accepted solution]

Create a calculated column,

IF(LEFT('Table'[Period],3) = "2nd H1","Jul - Dec","Jan - Jun")

Let me know if it works or not.

[Anonymous]

@SivaMani You are superstar ...

It worked like breeze   

PeriodYear = IF(LEFT(HCM[Period],3) = "2nd", "Jul - Dec", "Jan - Jun")

[SivaMani]

@Anonymous,

Thank you for your appreciation;)