Forum Discussion

Madhan_'s avatar
Madhan_
Frequent Visitor
4 years ago
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 ...
  • mangaus1111's avatar
    4 years ago

    you can use the following macro