Transform Fix

[Anonymous]

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)

INDEX	Attribute	VALUE	MEASURE	YEAR	TIME FRAME
1	SALES - CUR LATEST 12 WKS	366875.9567	SALES	CUR	LATEST 12 WKS
1	SALES - YAG LATEST 12 WKS	0	SALES	YAG	LATEST 12 WKS
1	SALES - CUR LATEST 26 WKS	721209.5977	SALES	CUR	LATEST 26 WKS
1	SALES - YAG LATEST 26 WKS	0	SALES	YAG	LATEST 26 WKS
1	SALES - CUR LATEST 52 WKS	721209.5977	SALES	CUR	LATEST 52 WKS
1	SALES - YAG LATEST 52 WKS	0	SALES	YAG	LATEST 52 WKS
1	SALES - CUR YTD	721209.5977	SALES	CUR	LES - CUR YTD
1	SALES - YAG YTD	0	SALES	YAG	LES - YAG YTD

[ALLUREAN · Accepted solution]

Hi, @Anonymous 

= Table.AddColumn(#"Changed Type", "Text After Delimiter", each Text.AfterDelimiter([Attribute], " ", 2), type text)

https://www.dropbox.com/s/5wkgtxps0pyfpq4/TIME%20FRAME%28allure-analytics.com%29.pbix?dl=0

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

[Anonymous]

@ALLUREAN 

Thank you but I have additional Attributes of varying length and your solution didn't address those. Sorry that I didn't let you know that I had other attributes.