Forum Discussion
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...
Hamdan1234
Add a custom column using the following code:Number.From(Text.Replace([Amount],"M" , "")) * 1000000
Hamdan1234
Add a custom column using the following code:
Number.From(Text.Replace([Amount],"M" , "")) * 1000000