Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |