Create a formatted name column

• The goal of this example is to implement a formatted name using the existing name (first, middle, and last) and Title columns of a customer dimension
• The target format is Mr. John A. Doe
• The query must account for nulls in the Middle Name and Title columns as well as different values in the Middle Name column:

1. Use Table.SelectColumns() to retrieve the required source columns.

1. Write a Table.AddColumns() function with an if...then expression that accounts for the different scenarios:

• Text.Range() is used to extract the first character of the middle name.

• The three if...then conditions account for all scenarios to return the formatted name as per the requirements defined in step 1.