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

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.

Daz4's avatar
Daz4
Icon for Helper I rankHelper I
5 years ago

Sort by - then choose date column.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    • Daz4's avatar
      Daz4
      Icon for Helper I rankHelper I
      5 years ago

      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. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.