Forum Discussion

NavaneethaRaju's avatar
4 years ago
Solved

Concatenate two columns using Calculated Measure

Hi, 

I have a doubt, regards concatenation.

I have to concatenate  two columns only using calculated measure, not calculated column. I dont want to create physical calculated column.

is we have any measure????

Please advice.

 

  • Hi, 

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    Expected result: =
    SELECTEDVALUE ( Data[Customer] ) & " / "
    & SELECTEDVALUE ( ( Data[Name] ) )
     

2 Replies

  • Hi, 

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

     

    Expected result: =
    SELECTEDVALUE ( Data[Customer] ) & " / "
    & SELECTEDVALUE ( ( Data[Name] ) )
     
  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NavaneethaRaju ,

     

    Could you tell me if your problem has been solved by Jihwan_Kim 's suggestion? If it is, kindly Accept it as the solution. More people will benefit from it.

     

    Or if you are still confused about it, please provide me with more details about your expected output to help us clarify your scenario.

     

    Best Regards,
    Eyelyn Qin