Forum Discussion

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

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

9 Replies

Shantanu00007
Helper I
8 years ago
Create a new column -> newcolumn = [column1]&[column2]
- 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
    Helper I
    8 years ago
    Could you please give a snapshot of the requirement and desired output ?
v-cherch-msft
Microsoft Employee
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