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.............   H...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi

     

    Try this

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

     

    Thanks
    Raj

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

Vathsala's avatar
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]