Forum Discussion

gusdahu's avatar
gusdahu
Helper IV
8 years ago
Solved

Concatenation Question

Hellow Power BI community,   I currently have a direct link from PeopleSoft to my Power BI. How can I concatenate two columns using the measurement functionality?   Regards, Gus Dahu
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    gusdahu

    To get the measure as requested, you may use SELECTEDVALUE Function:

    Measure :=
CONCATENATE (
SELECTEDVALUE ( 'Table'[Column1] ),
SELECTEDVALUE ( 'Table'[Column2] )
)


    Regards,
    Cherie

gusdahu's avatar
gusdahu
Helper IV
8 years ago

Shantanu0007,

 

I aprpeciate your quick response to my question. Unfortunately your solution did not work. Do you have any other alternatives?

 

Regards,

Gus Dahu

Gazzer's avatar
Gazzer
Resolver II
8 years ago

Forgive the possible patronising question, but did you substitute [column1] and [column2] for the actual names of your own columns in the supplied suggestion:

 

newcolumn = [column1]&[column2]

If you did, perhaps you could supply a screenshot of what happens when you try it? I'm wondering if it could be that one of the columns needs to be a different data type to make the concatenation work.

  • gusdahu's avatar
    gusdahu
    Helper IV
    8 years ago

    Hi Gazzer,

     

    I did input the actual names into the measurement formula. The measurement was created, however when I attempt to add the measurement as a column in the table, I receive a rejection from the visual itself telling me that the information cannot be displayed.

     

    Regards,

    Gus Dahu