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 want to create a measure showing a text1 before and text2 after a calculated column referenced in this measure. How can I do this?
The calculated column is a result of a division of two other columns, which is rounded to the whole number:
Number.Round(([#"column1"]/[#"column2"]),0,RoundingMode.AwayFromZero)
Thank you for your reply in advance!
Solved! Go to Solution.
Measure = "text1" & sumx( 'Table', column1 / column2) & "text2"
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |