The Currency data type, also known as Fixed Decimal Number in Power BI, stores a fixed decimal number. It can represent four decimal points and it is internally stored as a 64-bit integer value divided by 10,000. Summing or subtracting Currency data types always ignores decimals beyond the fourth decimal point, whereas multiplication and division produce a floating-point value – thus increasing the precision of the result. In general, if one needs more accuracy than the four digits provided, they need to use a Decimal data type.
The default format of the Currency data type includes the currency symbol. One can also apply the currency formatting to Integer and decimal numbers, and can use a format without the currency symbol for a Currency data type.
Contributors: Alberto Ferrari, Marco Russo