Forum Discussion

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

Shantanu00007,

 

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

 

Regards,

Gus Dahu