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

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft 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