Convert date to Quarter year

[Anonymous]

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?

[Anonymous · Accepted solution]

Hi

Try this

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

Thanks
Raj

[ThaoNguyen_18]

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]

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

[Anonymous]

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]

Hi @Anonymous

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

Best regards

maggie

[SteeltownRiot]

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.

[Daz4]

Sort by - then choose date column.

[SteeltownRiot]

That does tend to work in the table view, but never seems to work for me in visualizations.

[Daz4]

You can apply the sort in the data table, and this will reflect in the vis. So long as the sort column has only 1 to 1 relationship. Ive used this several times recently and never had any issues with it. ITs quite a useful feature. 

[SteeltownRiot]

It could be that recently this sticks so I'll have to try again. I've never been able to get the sort in a table to stick in a viz.