CURRENCY DAX Function (Math and Trig)
Returns the value as a currency data type.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| Value |
A scalar expression to be converted to currency data type. |
Return values
The value of the expression evaluated and returned as a currency type value.
Remarks
The CURRENCY function rounds up the 5th significant decimal, in value, to return the 4th decimal digit; rounding up occurs if the 5th significant decimal is equal or larger than 5. For example, if value is 3.6666666666666 then converting to currency returns $3.6667; however, if value is 3.0123456789 then converting to currency returns $3.0123.
If the data type of the expression is TrueFalse then CURRENCY( ) will return $1.0000 for True values and $0.0000 for False values.
If the data type of the expression is Text then CURRENCY() will try to convert text to a number; if conversion succeeds the number will be converted to currency, otherwise an error is returned.
If the data type of the expression is DateTime then CURRENCY() will convert the datetime value to a number and that number to currency. DateTime values have an integer part that represents the number of days between the given date and 1900-03-01 and a fraction that represents the fraction of a day (where 12 hours or noon is 0.5 day). If the value of the expression is not a proper DateTime value an error is returned
» 1 related function
Examples
-- CURRENCY converts any expression in a CURRENCY datatype
-- The Currency data type is called Fixed Decimal Number in Power BI
-- This data type stores 4 digits after the decimal point
EVALUATE
{
( "Currency 1", FORMAT ( CURRENCY ( 10 ), "#.00000" ) ),
( "Currency 2", FORMAT ( CURRENCY ( TRUE ), "#.00000" ) ),
( "Currency 3", FORMAT ( CURRENCY ( "1950.00" ), "#.00000" ) ),
( "Currency 4", FORMAT ( CURRENCY ( 190.29876 ), "#.00000" ) )
}
| Value1 | Value2 |
|---|---|
| 2001-01-01 | 10.00000 |
| 2001-02-01 | 1.00000 |
| 2001-03-01 | 1950.00000 |
| 2001-04-01 | 190.29880 |
Related articles
Learn more about CURRENCY in the following articles:
-
Understanding numeric data type conversions in DAX
This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results when using the same operations in other languages. » Read more
Related functions
Other related functions are:
Last update: Apr 2, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/currency-function-dax