Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Concantenate measures

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!

 

Need Help

4 Replies

  • JoHo_BI's avatar
    JoHo_BI
    Icon for Responsive Resident rankResponsive Resident
    8 years ago

    Hi Vanquisher,

     

    Try using the following: 

     

    Column = Latest Score &" "& Unit Measures

    Where Latest Score and Unit Measures are your column names.

     

    Hope that helps!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        JoHo_BI
        Icon for Responsive Resident rankResponsive Resident
        8 years ago

        Oops, apologies!

         

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

     

    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