Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Adding Units

I want to add a unit on each of my values

 

Desired Table

Measure 1     Values 

Profits          £500

Sales              30000

EBITDA          90%

 

 

How do I create a column/measure such that There's a unit corresponding my values?

I tried using concatenate, but numbers are transformed to text format, which is not ideal in my case.

 

Thank you!

 

Kind Regards,

 

Matt

Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    You use exactly as a column:

     

    Formated measure = FORMAT (SUM(Table[Column]), "### €")

    You can do it as I place it on top calculating your measure or make a new one and use the first measure on your syntax.

     

    Regards,

    Mfelix

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Anonymous,

     

    Don't know if your measures are in a single formula or using different ones, instead of concateneta you can use the FORMAT something like this:

     

    MEASURE = FORMAT ( [Measure]; "£ ###") 

MEASURE = FORMAT ( [Measure]; "###")

MEASURE = FORMAT ( [Measure]; "###%")

     

    Regards,

    MFelix

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Felix,

       

      Thank you very much! But  my measure is on one formula.. how do I use the FORMAT function if that's teh case?

       

      thank you!

      • MFelix's avatar
        MFelix
        Super User
        8 years ago

        Hi Anonymous,

         

        You use exactly as a column:

         

        Formated measure = FORMAT (SUM(Table[Column]), "### €")

        You can do it as I place it on top calculating your measure or make a new one and use the first measure on your syntax.

         

        Regards,

        Mfelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Another solution would be to format your visual as a MATRIX, and then in the values section of the formatting options, check the box for "Put Measures on Rows".

     

    That way you can put your 3 individual measures in the visual, and all of them can have their own formatting, as determined in the modeling tab.