Forum Discussion

Frequent Visitor

9 years ago

Solved

Add units

Hi, I would like to add "tons" unit in the column quantity. Thanks for you support. Regards, Jaouad

jaouad
9 years ago
Dear Victor,

Thank you for your help !!

Regards,

Jaouad

Frequent Visitor

9 years ago

Dear Bhavesh,

In the dashboard, I would like to add units like "tons".

Please check the picture below :

Thanks for your support,

Jaouad

Icon for Super User rank

Super User

9 years ago

For this, You need to convert your net weights to tons using DIVIDE function. There is no auto settings for this.

To do this,

Create below Measure,

Tons:=DIVIDE(Sum(Table1[NET WEIGHT]), 0.00110231,2)

This will give you the expected results.

jaouad
Frequent Visitor
9 years ago
Sorry, the values are already in tons. No calculation needed.

I want to add "tons" like "$" after or before the values.

For example : 1 000 tons, 1 000 $, 1 000 €...

I don't know where we can personalize the values in the dashboard.

Thanks & regards,

Jaouad
- Vvelarde
  Community Champion
  9 years ago
  jaouad
  
  Add in your measure the Word "Tons"
  
  Like this:
  
  ValueTons = CALCULATE(SUM(Table2[Value]) & " Tons")
  
  Replace the table and columns accord to your data.
  - jaouad
    Frequent Visitor
    9 years ago
    Dear Victor,
    
    Thank you for your help !!
    
    Regards,
    
    Jaouad

Related content