Forum Discussion
Solved
Add units
Hi, I would like to add "tons" unit in the column quantity. Thanks for you support. Regards, Jaouad
Dear Victor,
Thank you for your help !!
Regards,
Jaouad
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.
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
Add in your measure the Word "Tons"
Like this:
ValueTons = CALCULATE(SUM(Table2[Value]) & " Tons")
Replace the table and columns accord to your data.
