Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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)...
Need Help
Show and Tell
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    I dont have any other table.

    This is a new contract.

    What do you suggest?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    Thanks

    Jerry