Create column for custom unequal periods for date table

[grantadmin]

Hello,

I am trying to create a column on my date table that has periods of unequal length. I have created a table using CALENDAR for dates 1/01/2021 - 12/31/2023.

The periods I need to add are:

P1	1/1/2021 - 12/31/2021
P2	1/1/2022 - 3/31/2022
P3	4/1/2022 - 6/30/2022
P4	7/1/2022 - 9/30/2022
P5	10/1/2022 - 12/31/2022
P6	1/01/2023 - 3/31/2023
P7	4/01/2023 - 6/30/2023
P8	07/01/2023 - 09/30/2023
P9	10/01/2023 - 12/31/2023

The first period is 1 yr, and the rest are 3 months. 

If anyone has any insight, I would greatly appreciate it.

Thank you.

[Fowmy · Accepted solution]

@grantadmin 

Create a table in your model for the period, then add a column with the following DAX in the Calendar Table:

Period = 
VAR __Date = 'Calendar'[Date]
RETURN
    CALCULATE(
        MAX( Periods[Period] ),
         __Date >= Periods[Start],
        __Date <= Periods[End] 
    )

File is attached below 

[grantadmin]

This worked, thank you!