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. @amitchandak @moizsherwani MFelix regard...
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 )
