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 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)
Hi Anonymous
Click on the "New Column", then you could create a new column by inputing formula in.
Best regards
maggie
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.
Sort by - then choose date column.
That does tend to work in the table view, but never seems to work for me in visualizations.
