Pass Parameter (Drill Down) to Pick Name Format with Power Query

There’s a lot in this video! When you get this working, you’ll be entitled to wear your underwear outside your pants like a true Super Hero!

The challenge:
We’d like random names, but also choose which format we’d like our result in:
– First Name Last Name
– Last Name, First Name
– First Name MI Last Name
– Last Name, First Name MI

I thought about using a custom function but realized it’d be simpler to drill down (pass a parameter).

In this video you see:
– Column by Example
– Excel Tables
– Power Query
– Left Outer Join
– M Code
– Merge Columns
– and EVVYTHANG!

Download the file here:
http://datascopic.net/nformats
For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
#PowerQueryTutorial
#DrillDown
#OuterJoin

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2