Forum Discussion
Solved
How to Convert column having Text values as Million and Billion to number in Power BI
Hi I have text values in one column (Funding col), like $2.5M and $4.5B. I want to convert this column into a numerical one like 2,500,000 and 4,500,000,000 for the whole column. so I can calculate ...
you can use the following macro
mangaus1111
Solution Sage
Solution Sageyou can use the following macro
Yes, I have tried that. Now I am able to calculate. Whereas I am having doubt that will it works fine if more data will be added in the same format like 10M or 2B to the dataset in future.