Forum Discussion

Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Convert units

  Hi,   Column A:C are length, width and Height and column D is unit of dimension of each rows, column D contain multiple unit of dimension which is CM, MM and M.   How can I convert CM and MM i...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Saxon10 ,

     

    for each of the 3 columns (Lenght, Width and Height) add a calculated column:

    Length in Meter =
SWITCH(
    MyTable[UOM Dimension],
    "M", MyTable[Length],
    "CM", MyTable[Length] / 100,
    "MM", MyTable[Length] / 1000
)

     

    Same formula for the other 2 measures 😉 

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
Saxon10's avatar
Saxon10
Icon for Post Prodigy rankPost Prodigy
5 years ago

Thanks for your qucik reply. I am receving error here Exprssions that yield variant data-type cannot be used to define calulated column. 

 

Those three columns came from as a calculate column and those three column are stored as a text so can you please help me.

 

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Saxon10,

 

Try to create measures and apply selimovd's formula.

 

Best Regards,

Link

  • Saxon10's avatar
    Saxon10
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Thanks for the your reply. Now the problem is fixed and approved the solution