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

Shantanu00007's avatar
Shantanu00007
Helper I
8 years ago
Create a new column -> newcolumn = [column1]&[column2]
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

  • Shantanu00007's avatar
    Shantanu00007
    Helper I
    8 years ago
    Could you please give a snapshot of the requirement and desired output ?
    • gusdahu's avatar
      gusdahu
      Helper IV
      8 years ago

      Hi Shantanu00007,

       

      Basically I have a "PO_ID" column and a "Business_Unit_PO" column. I would like to concatenate the two to create a unique identifier to use in my analysis. I believe both columns are in text format although I am not 100% sure as I'm using the direct query feature from PeopleSoft which in turn disables a lot of Power BIs functionalities such as Edit Query.

       

      Regards,

      Gus Dahu

      • Shantanu00007's avatar
        Shantanu00007
        Helper I
        8 years ago
        Create a new column instead of new measure. Newcolumn=[PO_ID]&[Business_Unit_PO]
  • 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