Calendar - How to split a month in 2 Periods (Newbie looking for help)

[TapZxK]

Hi Guys, 

I have finally created a calendar table that is aligned with my organizations Fiscal Year.

Huge shout-out to @amitchandak for helping with that task. 

Now I would like to create a column that would represent a Month Period. 

Our months in the organization are split in to 2 periods. 

1st Period runs from the 1st of the month until 15th of the month.

2nd Period runs from the 16th of the month until end of that month. 

for example:

01.01.2020 - 15.01.2020 = January, Period 1

16.01.2020 - 31.01.2020 = January, Period 2

01.02.2020 - 15.02.2020 = February, Period 1

16.02.2020 - 29.02.2020 = February, Period 2

I was wondering if there is a way to create a column in my calendar that would split the months in to these periods? 

I would like for the column to be represented as such:

Reporting Period

February P1

February P2

March P1

March P2

April P1

April P2

etc.

My Fiscal Year Starts on 1st of September and Ends on 31st of August (If that helps)

My Current Calendar Table:

My Current Calendar Table

Best Regards,

Kris

[az38 · Accepted solution]

Hi @TapZxK 

try to create a calculated column

Reporting Period = 
var _period = IF(DAY('CalendarTable'[Date])<16," P1"," P2")
RETURN
CONCATENATE(FORMAT(CalendarTable[Date],"mmmm"),_period)

do not hesitate to give a kudo to useful posts and mark solutions as solution

[TapZxK]

Hi @az38,

Worked like a charm. 

Thank you very much. 

When I think about the logic behind this DAX it's actualy very simple.

It's just knowing how to express this logic in DAX that is what's challenging for me at the moment. 

Much appreciated.

BR,

Kris

[az38]

@TapZxK 

practice, practice, practice.. 

if you will struggling with smth - we will glad to help you

do not hesitate to give a kudo to useful posts and mark solutions as solution