cancel
Showing results for
Did you mean:
New Member

## Help with Data modelling!!!

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?

1 ACCEPTED SOLUTION
Community Support

Hi @ryba ,

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
2 REPLIES 2
Community Support

Hi @ryba ,

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Super User II

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.

Announcements