Partners filmexxx.link, sextotal.net, ahmedxnxx.com, https://xnxx1xvideo.com, russianxnxx

Hola People!

Hope you have been awesome and 2021 is turning out to be far better than the last year. It been a while since the last DAX / Power Query Challenge. So here is another one !

 

Here is a Quick Video..

 

Consider these names

Separate First Name and Last Name in Power Query

THE PROBLEM

  • Any of the above names can have none or one or more middle name / initials (letters).
  • Your challenge should you choose to accept is to get rid of all middle names / initials and extract the first and last name in a new column.

 

Sample Output

Once you’re done, here is how it should look like.

Separate First Name and Last Name in Power Query - Output

 

Rules

  1. Solve this using Power Query.
  2. Brownie Points are inversely related to the number of steps in your query 😉 i.e. keep it short.

 

 

Drop in a comment with your M code and the snapshot of the output. I’ll post the results on 2 Feb 2020.

Get going!

 



Topics that I write about...