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 All,
I'm trying to merge two columns= Latest Score + Unit Measure= Formated Score. But I just can't get the values to show up.
My Formula is Formatted Column= Concatenate(Latest Score, Unit Measures).
Not sure how to go around with this.
Thanks for the help!
Hi @vanquisher11,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
Hi Vanquisher,
Try using the following:
Column = Latest Score &" "& Unit Measures
Where Latest Score and Unit Measures are your column names.
Hope that helps!
Hi Joho,
Thank you!It did work, but now I have an issue with the format. How do I format it in away that only 2 decimals places is showing. e.g 98.25% rather than 98.25634% data is provided raw so I can't change the data. 😕
Thank you.
Oops, apologies!
If you wrap the numeric column in a FORMAT, with "Fixed" as the format, you'll always get 2 decimal places.
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |