Conditional Column IN power Query

[bdehning]

I want to add a Birth Date Field to the below column.  

[Claimant Last Name]&", "&[Claimant First Name]&" "&[Claimant Middle Name]&" -"

What do I need to do to add [Birth Date]?

[Ashish_Mathur · Accepted solution]

Hi,

Does this work

[Claimant Last Name]&", "&[Claimant First Name]&" "&[Claimant Middle Name]&" -"&Date.ToText([Birth Date])