Display a value with different units of measure

[JIblasco]

Good morning

I would like to know the best way to get the value of a column from a table with unit of measure. In this table I am saving different concepts, and depending on it, the value can be, "units", "seconds", "percentages". I mean:

id_concepto	Value	unit of measure	value to show
1	5	Seconds	5 sec.
2	5400	megabytes	5400 MB
3	75	Percentage	75%

What would be the best option?.

Thanks in advance.

[amitchandak]

@JIblasco , Try a measure like

sum(Table[Value]) & " " & max(Table[unit of measure]

[JIblasco · Accepted solution]

Good @amitchandak,

Thank you, instead of a measure I have made a new column in the query that concatenates both fields.

Best regards