Any way to convert a text field to numeric field from realtime data?

[SimpoPower]

Hello, I have a data set created from a microsoft flow from microsoft forms to power BI (a 'realtime data set').  I am having issues with the flow so may have to set all data outputs as 'text' format, even if they are numbers.

Is there anyway to convert the text fields to number fields so I can utilise the numbers, such as averaging etc?  

Or if anyone knows how to fix the original flow issue, my original request at the link below:

https://community.powerbi.com/t5/Desktop/Flow-failing-between-Forms-and-Power-BI-Any-help-much/m-p/7...

[SabineOussi]

Hey,

Try using the following in M query:
Number.FromText([Feedback])

It returns the numbers from the text.

Hope this helps!

Sabine O.

[SimpoPower]

Hello Sabine, 

As I understand this is a function that works when you import data from sources like excel?  My data is 'Realtimedata' streamed from forms being filled out, so not sure how to apply this M Query in Power BI Desktop.  Where would I do this?  The only option I can see available on the Power BI Desktop is to create a new Measure and apply a formula, however it doesn't seem to recognise this command