Card with Text String

[jmhoskinson]

I'm trying to write a measure to show a text string on a card. Ideally, the text string would be dynamic and would say something like "Jared was the top caller last month with 455 calls," The blue words being the content that needs to dynamically change. I started working with COMBINEVALUES and got stuck. Any help would be greatly appreciated.

[AlB]

Hi @jmhoskinson 

You need to specify how the dynamic parts would be determined. If it's through measures, for instance, you could something like this: 

Measure = 
[Measure1] & " was the top caller last month with " & [Measure2] & " calls" 

[jmhoskinson]

Yep! That example is exactly what I had in mind. Also, I forgot to mention that I need it to calculate calls for the last 4 weeks (not this week, but the four weeks prior). Thanks for the help!