- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
CURRENCY function
Description
Evaluates the parameter and returns the result as currency data type.
Syntax
CURRENCY (<value>)
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
value Any DAX expression that returns a single scalar value where the expression is to be evaluated exactly once before all other operations. |
Return Value
The value of the expression evaluated and returned as a currency type value.
Remarks
DAX 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.
If the data type of the expression is Logical (TRUE/FALSE), then DAX CURRENCY function will return $1.0000 for TRUE values and $0.0000 for FALSE values.
If the data type of the expression is Text, then DAX CURRENCY function 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 DAX CURRENCY function will convert the datetime value to a number and then that number to currency. If the value of the expression is not a proper datetime value, an error is returned.
Example
= CURRENCY (5.0) returns 5. = CURRENCY (55.55555555555) returns 55.5556.