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]

     

     

     

AlienSx's avatar
AlienSx
Icon for Super User rankSuper User
3 years ago
let
    Source = funding_table,
    new_funding = 
        Table.AddColumn(
            Source, "new funding",
            (x) => 
                try Number.From(Text.BetweenDelimiters(x[Funding], "$", "B")) 
                otherwise Number.From(Text.BetweenDelimiters(x[Funding], "$", "M")) / 1000
        )
in
    new_funding
kushal258's avatar
kushal258
Regular Visitor
3 years ago

Thanks AlienSx