Transform Fix

Hi there, 

I am having an issue with certain attributes not updating my TIME FRAME correctly and I know it has to do with the fact that my query step is saying take the last 13 characters of the attribute column to create the TIME FRAME column. How can I get the ATTRIBUTE fields that are YTD to display LATEST YTD? See the last 2 rows.

Here is the step that produces the TIME FRAME column as it is now:

= Table.AddColumn(#"Created CURYAG YEAR Column", "TIME FRAME", each Text.End([Attribute], 13), type text)