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 t...
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

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