Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Quarter based on predefined date range

I have a reference table room for Quarter. In my main table (table 1) I have to get the quarter next to the date column.

For example

the date of table 1 is 20-3-2019 then quarter should get Qtr 1 2019. So it is to check all the rows and give the quarter.

Start dateEnd dateroom
16-01-201915-04-2019Qtr 1 2019
16-04-201915-07-2019Qtr 2 2019
16-07-201915-10-2019Qtr 3 2019
16-10-201915-01-2020Qtr 4 2019
16-01-202030-04-2020Qtr 1 2020
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    You can  create a column for Quater in current table  with below code

     

     Get_Quater = "QTR " & QUARTER(Quater_data[Start date]) &" "& YEAR(Quater_data[Start date] )
     
    Screenshot for your reference
     

     

     

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    5 years ago

    You can  create a column for Quater in current table  with below code

     

     Get_Quater = "QTR " & QUARTER(Quater_data[Start date]) &" "& YEAR(Quater_data[Start date] )
     
    Screenshot for your reference