Forum Discussion

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............. H...

Anonymous
7 years ago
Hi

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

Thanks
Raj

Anonymous

Not applicable

7 years ago

Hi

Try this

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

Thanks
Raj

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
  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
  - Anonymous
    Not applicable
    6 years ago
    How do you get it to sort the quarters by time order? Tableau just did it. All I seem to be able to get PowerBI to do is sort on the associated measure.
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
  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
  - Vathsala
    New Member
    1 year ago
    Column = switch (true(),
    month(Table1[Date Received])>=4 && month(Table1[Date Received])<=6,"QTR I",
    month(Table1[Date Received])>=7 && month(Table1[Date Received])<=9,"QTR II",
    month(Table1[Date Received])>=10 && month(Table1[Date Received])<=12,"QTR III",
    "QTR IV") &" "& year(Table1[Date Received]

Related content