Forum Discussion

gomathisankar's avatar
gomathisankar
Regular Visitor
8 years ago
Solved

DAX weight calculation

hi,

I have a quantity column in my table. I have some quantity measures in bundles, others in kgs . I need all measures in kgs . 

I want to create a new column which contains  quantity in kgs. I'm new to DAX and i have no idea for how to convert bundles into kgs. 

Any idea would be great!

  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi gomathisankar，

     

    I found that this function SUBSTITUTE () may could help you.

     

    I have made a test, if your column is a text type, you could create a calculated column with formula below.

     

     

    Column = SUBSTITUTE('Table1'[kg],"Bundle","kgs")

     

     

    Hope this can help you!

     

    Best Regards,

    Cherry

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi gomathisankar，

     

    I found that this function SUBSTITUTE () may could help you.

     

    I have made a test, if your column is a text type, you could create a calculated column with formula below.

     

     

    Column = SUBSTITUTE('Table1'[kg],"Bundle","kgs")

     

     

    Hope this can help you!

     

    Best Regards,

    Cherry