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 Experts
Is it possible to concatentate three measure to produce the following output...
Measure 1 (measure 2, Measure 3)
11.82 (11.32, 12.45)
so the above is my result in power BI.
Solved! Go to Solution.
@Anonymous , try this DAX measure:
Combined Measure = VAR Part1 = [Measure 1] VAR Part2 = [Measure 2] VAR Part3 = [Measure 3] VAR Result = Part1 & " (" & Part2 & ", " & Part 3 & ")" RETURN Result
@Anonymous , try this DAX measure:
Combined Measure = VAR Part1 = [Measure 1] VAR Part2 = [Measure 2] VAR Part3 = [Measure 3] VAR Result = Part1 & " (" & Part2 & ", " & Part 3 & ")" RETURN Result
many thanks Chris....Excellent feedback. Works prefectly.
You can concatenate within a concatenate, if that's whatyour asking.
Can you show the data you wan't to get that ouput from?
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |