## How does the CURRENCY function (DAX) work?

The CURRENCY function (DAX) converts a decimal number into a generic currency value by effectively adding a generic currency symbol (¤), a decimal point, and one comma for every three digits preceding the decimal.

CURRENCY(
<value>
)

## How do you use the CURRENCY function?

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.

## Related Support Forum Posts

Multi currency with correct currency label
Time intelligence fucntion inside Vlookup (need to create the ROW by currency context inside DAX)
Converting currency

## Considerations when using the CURRENCY function

• If the data type of the expression is TrueFalse then CURRENCY( <TrueFalse>) will return \$1.0000 for True values and \$0.0000 for False values.
• If the data type of the expression is Text then CURRENCY(<Text>) will try to convert text to a number; if the 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(<DateTime>) 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 days). If the value of the expression is not a proper DateTime value an error is returned.

## Formula examples using the CURRENCY function

=CURRENCY(1234.56)

= CURRENCY (55.55555555555)

currency(3213.43)