Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |