Forum Discussion

Saxon10's avatar
Saxon10
Post 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
     
selimovd's avatar
selimovd
Most Valuable Professional
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