cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pellegrino
Frequent Visitor

convert mathematical equations stored as text into the mathematical answer within m

Pellegrino_0-1636175294843.png

 I have a simple equation stored as text. Is there a straight forward manner in which I can convert this to the mathematical answer, instead of splitting the colums by the + delimeter, storing the split mumers as a numer and then creating a new colun to get what I want?

 

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

Expression.Evaluate  with the column should do it

View solution in original post

3 REPLIES 3
Sorina
Frequent Visitor

I have the same problem - I need to evaluate a math expression like: 

((1038*1000000)/27011675)
((32*1000000)/7152834)
((1038*1000000)/27011675)
((32*1000000)/7152834)
HotChilli
Super User
Super User

Expression.Evaluate  with the column should do it

soz hotchilli, but as a newbie to m i still can't get my head around it. Here is the query i have. It's gone through a number of steps to get to the below. How do I use Expression.Evaluate against the whole query, which for the sake of simplicity is called #"Nearly There".  I want to Evaluate the entire column Entry Fee. Thanks in advance

 

 

Pellegrino_0-1638639350032.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors