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.
Hello everyone,
I got a column from a data set in which the Amounts of the Journal Entries are stored. Power query didn't recognize it as number, and kept it as text. Whenever I try to apply convert to currency the operation works, however numbers get messed up, e.g.: 435,97 will become 43597.
Any ideas on how to solve that?
I tried Replace.Value with Number.FromText and it hasn't worked either.
If i had to guess, its possibly a language settings issue. I know under my language settings that a number 435,97 would be expected to have been stored as 435.97 instead, however if it saw 435,97 it would drop the comma as typically those are used to separate numbers from purely a display aesthetic (typically to break up thousands, millions, billions etc)
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |