Convert M to Million

[Hamdan1234]

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

[Fowmy · Accepted solution]

@Hamdan1234 

Add a custom column using the following code:

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