Converts text to number.
Syntax
Tutorial with example
In today’s video we will be covering VALUE, YEAR and WEEKNO, to create a dashboard that shows data from the previous week. It is easier than you think, but if your weeks don’t start on Sunday and you have a week number column that you need to sort using a fiscal calendar, then it gets a bit trickier to do that.
Download example file:
Download Power BI file: here.
Remarks
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.
Leave a Reply