Forum Discussion

kushal258's avatar
kushal258
Regular Visitor
3 years ago
Solved

Converting the Data Type

Suppose I have a column in this way and want to convert it to whole number data type to perform certain calculations, then how can it be done? I did try creating a new column in Power Query by...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    Hi, 

    try this 

    if [Column1.2] ="M" then Value.Multiply([Column1.1.2],0.001) else [Column1.1.2]

     

     

     

kushal258's avatar
kushal258
Regular Visitor
3 years ago

Thank you for your feedback,

I did try that earlier but there is still one problem. There are certain values in Millions ($USD) and other values in Billions ($USD). So I would have to add "0." to values which are in Millions ($USD). 

 

serpiva64's avatar
serpiva64
Icon for Solution Sage rankSolution Sage
3 years ago

Please make an example of what you want to achieve