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 there a way to convert it with power query not with DAX?

Thanks

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

     



1 Reply

  • 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