Thanks for the reply but this hasn't worked for me.
In my original data I have my data in the database as a string (2018-Q3, 2015-Q4 etc.).
I have used two calculated fields to split the string into year info and quarter info using SPLIT( [Quarter Year], "-", 1 ) and SPLIT( [Quarter Year], "-", 2 ).
I've tried to convert these new columns to date format but it screws up my table above into absolute dates.
1 of 1 people found this helpful
Use the dateparse to convert string to date
I have taken sample data based on your input
Create date parse calculation to convert your string to data using below cal
Now you will get the YoY Growth enabled
Hope this helps Plz mark this answer as correct or helpful to close the thread
By the way, automatic date parse will handle this situation too. Just click on the field and change the data type to date. It will figure out your format so you don't have to write your own DATEPARSE calculation.