concatenate strings

[Pete230]

Hi there,

I struggeling since a few days with the following: I would like to concatenate a fixed word "Hello" and a string e.g. the column

maindata[Prognosis] chosen by a slicer. Depding on the selection I would like to display in a Hello A,

Hello B, Hello C...
I tryed this:

concatenate ("Hello",maindata[Prognosis]) the issue is maindata[Prognosis] cant be found, altough its clearly there.

It just shows me all my muessure to be selected but not he column

Im sure its an easy fix, which I cant see right now.

BR Pete

[Pete230]

It works, thanks for the easy fix!

[Greg_Deckler · Accepted solution]

@Pete230 Try:

Measure = "Hello" & SELECTEDVALUE('maindata'[Prognosis])