topic Re: Concatenation Question in Desktop

Concatenation Question

gusdahu — Wed, 25 Jul 2018 14:15:39 GMT

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

Re: Concatenation Question

Shantanu00007 — Wed, 25 Jul 2018 14:22:16 GMT

Create a new column -> newcolumn = [column1]&[column2]

Re: Concatenation Question

gusdahu — Wed, 25 Jul 2018 14:26:05 GMT

Shantanu0007,

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

Regards,

Gus Dahu

Re: Concatenation Question

Shantanu00007 — Wed, 25 Jul 2018 14:30:16 GMT

Could you please give a snapshot of the requirement and desired output ?

Re: Concatenation Question

gusdahu — Wed, 25 Jul 2018 14:34:15 GMT

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

Re: Concatenation Question

Gazzer — Wed, 25 Jul 2018 14:34:38 GMT

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.

Re: Concatenation Question

gusdahu — Wed, 25 Jul 2018 14:42:13 GMT

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

Re: Concatenation Question

Shantanu00007 — Wed, 25 Jul 2018 14:45:44 GMT

Create a new column instead of new measure. Newcolumn=[PO_ID]&[Business_Unit_PO]

Re: Concatenation Question

gusdahu — Wed, 25 Jul 2018 14:47:28 GMT

Shantanu00007,

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

Regards,

Gus Dahu

Re: Concatenation Question

v-cherch-msft — Fri, 27 Jul 2018 09:38:28 GMT

gusdahu

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

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

Regards,
Cherie