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.
Hi
I need to concatenate a measure and a column
Example for Volume I have quantity
To find total volume I do sum(quantity), but the unit of measurement is in different column which is a string.
How do I combine both the values
Say 100 KG --> 100 comes from sum(quantity) and KG is present in different column.
Thanks
New Column = [Measure] & " " & [Column]
Hi Greg,
Really thanks for the prompt reply.
However I donot want a column, all I want is simple.
I have two colums, one quantity (numeric) and one UOM (text)
I want summation over quantity say sum(quantity) which gives me 100, now I need to put this value in chart and show the result as 100 KG...this KG comes from UOM column which is a string.
I would be obliged to connect with you, I work from India and support US hours. Let me know a way to connect to you.
Maybe whatsapp ? +91 8765045961
Best Regards
[Volume] & " " & SELECTEDVALUE( T[ColumnWithUnit] )
But if this works... it means the design is flawed 🙂
Best
D
Hi Greg,
Thanks for the help again. Unfortunately I am unable to put the filed in Value for a bar chart.
Regards
Anindya
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |