Forum Discussion

Hamdan1234's avatar
Hamdan1234
Icon for Helper III rankHelper III
4 years ago
Solved

Convert M to Million

I have the data where it shows the sales in this format 1.36M now I want the Power query to convert it in 1360000. Is their any way ? I have tried doing it with Replace value but did not work. Is the...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Hamdan1234 

    Add a custom column using the following code:

    Number.From(Text.Replace([Amount],"M" , "")) * 1000000

     



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Hamdan1234 

Add a custom column using the following code:

Number.From(Text.Replace([Amount],"M" , "")) * 1000000