Forum Discussion
Imported Numbers in Millions
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 Po...
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