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

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]
      • gusdahu's avatar
        gusdahu
        Helper IV
        8 years ago

        Shantanu00007,

         

        The New Column option is greyed out as my data is directly connected to PeopleSoft.

         

        Regards,

        Gus Dahu