Lookup value from one column to another, or, associating x axis with specific text

[emilymgoitia]

Hello.

I would like to create a bar graph that explains the reasons that a scheduled date has improved.  For this example, there will be two reasons, 'dates matched' or 'pull in'.
These three columns come directly from my data source.  Comments may or may not be retained week over week.  They are generally retained until replaced.  

This is a paired down example of what my data looks like.

Work Week	Scope	Comments
11	111	WW09:  Pull in due to expedited shipping.
11	222	WW10:  Delay due to a reason.
11	333	WW11:  Dates aligned.
12	111	WW09:  Pull in due to expedited shipping.
12	222	WW10:  Delay due to a reason.
12	333	WW11:  Dates aligned.
13	111	WW13:  Pull in due to condensed schedule.
13	222	WW10:  Delay due to a reason.
13	333	WW11:  Dates aligned.
14	111	WW14: Pull in due to reasons.
14	222	WW14:  Dates aligned.
14	333	WW14: Pull in due to efficiencies.

This is the value that I would like to retrieve based on my example data above.

11	1	Dates aligned
11	0	Pull in
12	0	Dates aligned
12	0	Pull in
13	1	Dates aligned
13	0	Pull in
14	1	Dates aligned
14	2	Pull in

This is where I am with my real data.

I can't simply take the variance between weeks.  I believe that I need to associate the x axis with the text in the comments, or, look up in the comments for the results in the work week column.  
Any ideas?

[emilymgoitia]

This worked beautifully, and seems so easy once you layed it out like that.  Thank you so much!

[jdbuchanan71 · Accepted solution]

You could add a calculated column to your table like this.

Category = 
IF (
    CONTAINSSTRING('Table'[Comments],'Table'[Work Week]),
    SWITCH(
        TRUE(),
        CONTAINSSTRING('Table'[Comments],"Pull In"),"Pull In",
        CONTAINSSTRING('Table'[Comments],"Dates aligned"),"Dates aligned"
    )
)

It will populate with "Pull in" or "Dates aligned" base on the comment containing the same number as the work week and the the if it does the comment containing one of those two strings.

Then you use the new Category column in your visual and filter out blanks.