Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Convert date to Quarter year

Hi All,

 

I have a date column in my database and I want to convert it to quarter year format.

 

eg:

12/04/2017 ->  Q4 2017

11/14/2017 -> Q4 2017

08/20/2017 -> Q3 2017 

etc.............

 

How can i achieve this?

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi

     

    Try this

    Column = Table1[Date Received].[Quarter] &" " & Table1[Date Received].[Year]

     

    Thanks
    Raj

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi

     

    Try this

    Column = Table1[Date Received].[Quarter] &" " & Table1[Date Received].[Year]

     

    Thanks
    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Rajendra,

       

      Thank you for the prompt reply. I cannot seem to write the code in my column. the formula box is greyed out(marked in red)

       

       

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi Anonymous

        Click on the "New Column", then you could create a new column by inputing formula in.

         

        Best regards

        maggie

    • ThaoNguyen_18's avatar
      ThaoNguyen_18
      New Member
      3 years ago

      Hi Raj,
      I have tried 
      Column = Table1[Date Received].[Quarter] &" " & Table1[Date Received].[Year]

      As

      Quarter Year = 'Calendar Table'[Date].[Quarter] &" " & 'Calendar Table'[Date].[Year]
      But it didn't work
      Please correct my mistake if any
       
      Many thanks

       

      • krishanw's avatar
        krishanw
        Helper II
        3 years ago

        This is worked for my, only issue I'm having is need to change fiscal year Q1 start month as April