Concantenate measures

[vanquisher11]

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!

[v-jiascu-msft]

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

[JoHo_BI]

Hi Vanquisher,

Try using the following: 

Column = Latest Score &" "& Unit Measures

Where Latest Score and Unit Measures are your column names.

Hope that helps!

[vanquisher11]

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.

[JoHo_BI]

Oops, apologies!

If you wrap the numeric column in a FORMAT, with "Fixed" as the format, you'll always get 2 decimal places.