How to Convert Text values (with Million dollar and Billion dollar) to number in Power BI

[Aman_]

Hi

I have text values in one column containing values like $2.5M and $4.5B . I have to convert this column into numerical column so that I can do calculation on this . Please provide solution

[SpartaBI]

@Aman_ 
Power Query: replace all the characters that are no digits with nothing. 

Than change the type of the column from TEXT to whole number or currency and upload to the model.
You can always format them with $ again in the model.

[Aman_]

Hi

Thank you for your reply , In column Some values are given in M (Million) and Some in given as B (Billion) like 2.5M , 1.5B, 7.0M . How to deal with this and convert into single format say thousand

[SpartaBI · Accepted solution]

@Aman_ create this column in DAX:

Column = 
VAR _factor = RIGHT(Table1[Column1])
VAR _number = VALUE(LEFT(Table1[Column1], LEN(Table1[Column1]) - 1 ))
VAR _result = 
SWITCH(
    TRUE(),
    _factor = "B", _number * 1000000000,
    _factor = "M", _number * 1000000
)
RETURN
    _result

In case it solved your question, pleasw accept this as a solution. Appreciate your Kudos.