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 a set of financial statements which are in millions. (There is no way of obtaining the data without rounding to the nearest millions)
What are the best way
(1) Import the numbers into Power BI and multiple all number columns by 1000000 (I tried to use "Transform", Multiple by 1000,000 but this can only be applied column by column)
(2) Alternate way is to "tell" Power BI that all the numbers are rounded to the nearest millions (not sure if this is at all possible), so that the visuals will be displayed correctly.
Appreciate much!
HI @alvinyong,
So you mean your table contains both abbreviation million unit records and normal unit records? If this is a case, any specific character that remarks the current unit in your records? (e.g. K, M with numeric value)
For this scenario, you can add a calculated column with if statement and text function to check if 'K, M' character exists and extract number value to multiply with 1,000 and 1000,000.
If not, please provide some dummy data with a similar data structure to test and coding formula:
How to Get Your Question Answered Quickly
BTW, #2 is impossible to achieve on power bi side.
Regards,
Xiaoxin Sheng
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |