VALUE DAX Function in Power BI
The VALUE DAX function converts a text string that represents a number to a number.
DAX Syntax
VALUE(text)
The parameter text specifies the text string that represents a number, which we want to convert.
Example: Lets we have the following table named “Students”. In this table we have one column named “Marks” which contains the marks of the students, but its datatype is Text, as shown in the image below.
Let’s create a Calculated table, by clicking on “New Table” from the Table tools menu, and specify the following dax formula to it.
DAX
Table 5 = FILTER('Students', VALUE([Marks]) >30)
The output of the above dax formula is shown below:
If we do not use the Value function, then it gives an error as shown below:
