Power Query for Custom Column

[im_newbie_123]

I have three columns Last Name, First Name and Preferred Name. 

Some of the records in these are NULL.

I have to create a custom column called Person Name which will have data like below, based on last name,first name and preferred name.

For example : 

Expected Output :

Last name                  First Name                   Preferred Name                    Person Name

Hans                           Samuel                        NULL                                     Hans, Samuel

Alfred                          NULL                           NULL                                     Alfred

Kennedy                     John                            Joe                                         Kennedy, John (Joe)

-----------------------------------------------------------------------------------------------------------------------------

My Query :

My query

This generates values like :

Person Name

NULL

NULL

Kennedy, John (Joe)

[Anonymous · Accepted solution]

Try this formula

Text.Combine({[Last Name],[First Name]},", ") &
(if [Preferred Name] = null then "" else " ("&[Preferred Name]&")")