Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Resolver III
4 years ago
Solved

Create Different Date bands

Hey everyone,

 

I want to create a few Date Bands and we have 2 different Dates, the 1st one is the system date, which shows the date that something was imported to the System and 2nd date is "Stay Date" which shows when one client stays in one Hotel.

 

We have 2 different seasons, meaning the full year created by "Stay Date". Let's say 2022 and 2021.

One Client might make a reservation from July 2021 to Dec 2022 (System Date) for Season 2022 or 

July 2020 to Dec 2021 (System Date) for Season 2021.

 

So I want to create some date periods and a graph like this

 

Any idea ?

 

Keep in mind the notes above 🙂

 

Thanks in advance

 

Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    SpiroswayGR , You have create a new column in date table  

     

    Switch(True(),

    [Date] >= date(2021,07,01) && [Date] <= date(2022,1,31) , "Jul 2021 to Jan 2022",

    [Date] >= date(2022,02,01) && [Date] <= date(2022,3,31) , " Feb - Mar 2022",

    format([Date], "mmm-yyyy")