Help with Data modelling!!!

[Anonymous]

Guys, could you please help me?

I have just started to learn Power BI and faced a problem ;(

I have a table with customers and measures: "Count of purchase", "Count of purchased goods", "Amount";
need to write a measure which will display such text: "This customer has bought [Count of purchase], [Count of purchased goods] goods, paid [Amount] USD". 

How can I solve this?  

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You could use & symbol. Check the formula.

Measure = "This customer has bought "&[Count of purchase]&", "&[Count of purchased goods]&" goods, paid "&[Amount]&" USD"

 

Best Regards,

Jay

[jdbuchanan71]

@Anonymous 

When you say you have measures in a table do you mean you wrote a measure like this.

Count of purcase goods = SUM ( Sales[Quantity] )

or that there is a column in your table called 'Count of purchased goods' like this.