Merge Columns

[sdhn]

Hi All

I have a single table.

I want to  merge 3 columns and name as first column. 

First column has a datatpe Text . 

Second column Whole Number.

Third column Whole number.

First column has single Alphabets.

sample data

column 1: A

column 2: 007

column 3: 911

I want to dispaly as

A-007-911

Thanks in advance.

[sdhn · Accepted solution]

I did.  Thanks for your help.  I used mege feature of Power Bi. I highlighted 3 columns and used merege coulmns featur. 

[AlexisOlson]

If columns 2 and 3 are numeric types, then you'll need to convert to text before combining and pad with zeros.

Try a custom column like this:

[Column1] & "-" & Text.PadStart(Text.From([Column2]), 3, "0")
          & "-" & Text.PadStart(Text.From([Column3]), 3, "0")

[sdhn]

Thanks

I changed dataype to text for column 2 & column 3. 

Did you write a measure above?

I have multiple fields. 

[AlexisOlson]

No. This is a calculated column using the M language in the query editor.

Measures use DAX.