Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @Ali123
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcC
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
)
Hi @Ali123
I know it might be much more complex but based on this sample data please use https://www.dropbox.com/t/HzAd6VMSMQVVBBcC
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
)
Name | Salary |
Abubakar | $22M |
Akbar | $1B |
Asgar | Unknown |
Arif | $2M |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |