Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Concatenate

Hello All,

 

I need help to Concatenate three columns into one field.

 

Note

Table ='Aquisition- On and ROC'

Field 1 = 'Aquisition- On and ROC'[OntROC]

Field 2 = 'Aquisition- On and ROC'[CurrNewFunded]

field 3 = 'Aquisition- On and ROC'[PriNewFunded]

 

Field 2 and 3 are decimal/numbers while field 1 is text.

 

I tried this 

Concatenate = 'Aquisition- On and ROC'[PriNewFunded] & "-" & 'Aquisition- On and ROC'[CurrNewFunded] & "-" & 'Aquisition- On and ROC'[OntROC]
 
but didn't get solution.
 
Please help. 
 
Cheers- Paul 
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous 

    You can use CONCATENATE() function.

    e.g 

    Column = CONCATENATE([PriNewFunded]&"-"&[OntROC],"-"&[CurrNewFunded])

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous 

    You can use CONCATENATE() function.

    e.g 

    Column = CONCATENATE([PriNewFunded]&"-"&[OntROC],"-"&[CurrNewFunded])

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you . I really appreciate it 

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    I think you're running into a type issue. You will need to convery fields 2 and 3 to a text type using either the FORMAT function in DAX or in Power Query. You can then use the formula you have to concatenate the text (or you can also do that in Power Query with Text.Combine)

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for replying. But field 2 and 3 are numbers.