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'[CurrN...
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.

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.