Convert Date into New Column with Quarter and Year

[Anonymous]

Trying to create a new column that takes the date and converts it into the Quarter + Year. The column that has the dates in it is formatted YYYY-MM-DD When I use the following: Column = 'Sold'[SoldDate].[Quarter] & " " & 'Sold'[SoldDate].[Year] I get the error that "Sold cannot be used with a variation 'Quarter' because it does not have any"

[ChrisMendoza · Accepted solution]

@Anonymous -

I'd guess that your [SoldDate] is of data type Text. If data type is Date then it works for me as is.