CURRENCY function


Advertisements

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. 
dax_functions_mathematical_trigonometric.htm

Useful Video Courses


Video

Mastering DAX and Data Models in Power BI Desktop

53 Lectures 5.5 hours

Abhay Gadiya

Video

Mastering DAX Studio

Featured

24 Lectures 2 hours

Randy Minder

Video

DAX / Power BI - Customer and Sales Analysis Deep Dive

26 Lectures 4.5 hours

Randy Minder

Advertisements