Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.