VALUE Function (DAX)

How does the VALUE function (DAX) work?

The VALUE function (DAX) converts a text string that represents a number to a number.

VALUE Formula Syntax

VALUE (
     <text>
)

How do you use the VALUE function?

The VALUE function converts text that appears in a recognized format (i.e. a number, date, or time format) into a numeric value. This function is used for compatibility with other spreadsheet programs.

Related Blog Posts

Related Support Forum Posts

Allocating a total value in column based on proportional values in another column
Switch True with measure between range values
Calculating Current Period Values from YTD values

Considerations when using the VALUE function

The value passed as the text parameter can be in any of the constant, number, date, or time formats recognized by the application or services you are using. If text is not in one of these formats, an error is returned.

You do not generally need to use the VALUE function in a formula because the engine implicitly converts text to numbers as necessary.

You can also use column references. For example, if you have a column that contains mixed number types, VALUE can be used to convert all values to a single numeric data type. However, if you use the VALUE function with a column that contains mixed numbers and text, the entire column is flagged with an error, because not all values in all rows can be converted to numbers.

Related Video Tutorials

Calculating Averages Per Transaction Using DAX in Power BI

Formula examples using the VALUE function

=VALUE(“3”)

=VALUE(“67”)

=VALUE(A2)

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership