How to simply convert text values into numbers in Power BI


I’m converting some imported data from xls. In xls, FieldName(“PEPM Revenue”) is formatted as a currency. But in BI, it is a text field. What syntax should I use to convert this into number format?

Thank you for your help.

Welcome to the forum! How did you bring in your data into Power BI? Power BI brought in the data that way, but you can edit it in the Query Editor. Here is an example of the different options you have( All I did was left click on the ABC in the highlighted column):


Some other simple options as well

You can simply choose number or currency from the Modeling tab in the Data Type section to convert your data, or you can use the VALUE function.