Forum Discussion
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...
Hi
Try this
Column = Table1[Date Received].[Quarter] &" " & Table1[Date Received].[Year]
Thanks
Raj
Hi
Try this
Column = Table1[Date Received].[Quarter] &" " & Table1[Date Received].[Year]
Thanks
Raj
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
Please correct my mistake if any
Many thanks
- krishanw
Helper II
This is worked for my, only issue I'm having is need to change fiscal year Q1 start month as April
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]
