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]

     

     

     

serpiva64's avatar
serpiva64
Solution Sage
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 Serpivs64. It has worked