Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ali123
Frequent Visitor

Replace/Convert Values in columns

I have values in my column like : $2B ,$22M, $15B and some are 'unknown'.
How we can convert these values into digits .

for example $2m --> 2000000.

@amitchandak

@moizsherwani 
@MFelix 


regards

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Ali123 
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcC

1.png

Salary New = 
VAR Salary = Salaries[Salary]
VAR Length = LEN ( Salary )
VAR Number = MID ( Salary, 2, Length - 2 )
RETURN
    SWITCH ( 
        TRUE ( ),
        CONTAINSSTRING ( Salary, "M" ), 1000000 * Number,
        CONTAINSSTRING ( Salary, "B" ), 1000000000 * Number
    )

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Ali123 
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcC

1.png

Salary New = 
VAR Salary = Salaries[Salary]
VAR Length = LEN ( Salary )
VAR Number = MID ( Salary, 2, Length - 2 )
RETURN
    SWITCH ( 
        TRUE ( ),
        CONTAINSSTRING ( Salary, "M" ), 1000000 * Number,
        CONTAINSSTRING ( Salary, "B" ), 1000000000 * Number
    )
tamerj1
Super User
Super User

Hi @Ali123 
Would you please provide some sample data?

NameSalary
Abubakar$22M
Akbar$1B
AsgarUnknown
Arif$2M

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors