Forum Discussion
Custom Date Table - period description
hi,
I work in the rail industry.
We have for example:
Period 1 = 01/04/2021 to 01/05/2021
Period 2 = 03/05/2021 to 29/05/2021
- I have a basic date table (below is my current date table code)
- How can i add Period 1 (Decscription) to incorporate this date periods only?
Date =
ADDCOLUMNS (
FILTER (
CALENDARAUTO( ),
AND ( YEAR ( [Date] ) >= 2021, YEAR ( [Date] ) <= 2026 )
),
"Calendar Year", "CY " & YEAR ( [Date] ),
"Month Name", FORMAT ( [Date], "mmmm" ),
"Month Number", MONTH ( [Date] ),
"Weekday", FORMAT ( [Date], "dddd" ),
"Weekday number", WEEKDAY( [Date] ),
"Quarter", "Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1
)
Thank you
3 Replies
Anonymous , do you have any table where you have these periods if yes you can add additional columns based on that
Start Date = minx(filter(period, peiord[Start Date] <= Date[Date] && peiord[end Date] >= Date[Date] ), peiord[Start Date] )
same way
end Date = minx(filter(period, peiord[Start Date] <= Date[Date] && peiord[end Date] >= Date[Date] ), peiord[end Date] )
