Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.