Challenge #358: Goodbye, Michael! (Part 1)

[olga_strubbe]

Spoiler

My numbers came a bit different, just the # seasons match the solution, the rest are the same as @mmontgomery solutuion with exception of last one, as it appears the dataset version is slightly different. 

Nice challenge, nevertheless, thank you!

[Sebastian_Chaieb2]

First approach (Filter: character = 'Michael') outputted different results so I investigated "character" field and observe that there is many typos and mistakes. 

Second approach with Fuzzy match again gave me wrong data.

Last option was corrected (Filter: Contains(character,  'Michael').

So the exercise is not perfect :)

Spoiler

[lucascs]

solved

[akorte1]

Done

[RyanG45]

This was a tricky one at first - need to be careful in how you filter for "Michael" as the data isn't super clean  

Spoiler

Use a contains instead of an equals to 

[martinding]

Submitted

[alisonpitt]

Can't wait for part 2!

Spoiler

[Amy_smart]

I have attached my solution. 

[Turley93]

Solution

[poojasrivastava]

Did it.