please write the below calculation and drop to column shelf as shown in below figure.
IF CONTAINS([New Format],"YTD") THEN [New Format]
ELSE TRIM( SPLIT( [New Format], "(", 1 ) )
please find attached workbook sheet2 for your reference.
Axis.twbx 13.3 KB
Thank you so much that helped me a lot!