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

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity 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's avatar
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.