Forum Discussion
Solved
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.
regards
Hi Ali123
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcCSalary 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 )
3 Replies
Hi Ali123
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcCSalary 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 )Name Salary Abubakar $22M Akbar $1B Asgar Unknown Arif $2M
