POwer BI DAX Function for "CONVERT"

[Anonymous]

How to Convert kg to ton through Power BI DAX function.  What is the alternate function for "CONVERT" in Power BI.

For Example, I am having tables Quantityuomid, Quantity

Quantityuomid
3
4
5

Quantity
2
10
100 respectively.
In my Database I'm having like this. Now, I want to convert the "Quantity" column in Power BI through DAX function like below:

Quantity(ton)
0.00220462
10
11.0231

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

If you know the convert rate between KG and TON, you could directly add a new column:

Quantity(ton)='Table'[Quantity] * rate

Reference:Function convert in Power BI

Best regards,

Yuliana Gu

[Anonymous]

How to Convert kg to ton through Power BI DAX function.  What is the alternate function for "CONVERT" in Power BI.

For Example, I am having 2 Columns Quantityuomid, Quantity

Quantityuomid
3
4
5

Quantity
2
10
100 respectively.
In my Database I'm having like this. Now, I want to convert the "Quantity" column in Power BI through DAX function like below:

Quantity(ton)
0.00220462
10
11.0231