- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
DAX Text - VALUE function
Description
Converts a text string that represents a number to a number in numeric data type.
Syntax
VALUE (<text>)
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
text The text to be converted. |
Return Value
A number.
Remarks
The text parameter for the DAX VALUE function can be a constant, a number, a date, or a time in DAX data types.
If the text is not in one of these following formats, DAX VALUE function returns an error.
If the text represents an integer, the integer is returned.
If the text represents a decimal number with only zero values to the right of the decimal point, then the integer part only is returned.
If the text represents a decimal number, then the decimal number is returned.
Example
= VALUE ("5") returns 5.
= VALUE ("5.0") returns 5.
= VALUE ("5.1") returns 5.1.
dax_functions_text.htm
Advertisements