Custom Date Table - period description

[Anonymous]

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

[amitchandak]

@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] )

[Anonymous]

Hi amitchandak
Where in my code, would i insert the code you suggested?

Thanks

Jerry

[Anonymous]

I dont have any other table.

This is a new contract.

What do you suggest?