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

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