Forum Discussion
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: ...
Anonymous
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
Fowmy
Super User
Super UserAnonymous
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
This worked, thank you!