Forum Discussion
Pete230
3 years agoHelper III
concatenate strings
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:
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 Try:
Measure = "Hello" & SELECTEDVALUE('maindata'[Prognosis])
2 Replies
- Greg_DecklerCommunity Champion
Pete230 Try:
Measure = "Hello" & SELECTEDVALUE('maindata'[Prognosis]) - Pete230Helper III
It works, thanks for the easy fix!