cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Create column for custom unequal periods for date table

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.

1 ACCEPTED SOLUTION
Super User

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
2 REPLIES 2
Super User

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

Did I answer your question? Mark my post as a solution! and hit thumbs up
New Member

This worked, thank you!