Forum Discussion
Solved
Dynamic Text
Hello, Is there a way that I can create a dynamic text within the text box? In other words, let's say I want to display the following: There are @numberoftickers submitted by @numberofusers ...
What you can do is to create a measure like
TextMeasure = "There are " + [numberoftickers] + " submitted by " + [numberofusers] + " and managed by " + [numberofadmins]
Now you can place this measure in a text box and that should show the desired result. Using text based measures is a handy technique in scenarios like this.
SqlJason, & is the concatenation operator in DAX; + is not overloaded as in SQL.
As an additional point, depending on the measure being used to provide the numeric portion of this string, you may find a need for FORMAT(), which allows you to use a format string to alter the display of a numeric or date value.