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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Sorina
Frequent Visitor

Evaluate mathematical equations / operators as text

Hi all, 

 

I have a calculated column in Power BI - below image.

I need to return the calculation of these equations:

Sorina_0-1671033129501.png

Is it any way to evaluate this calculations?

 

Thank you very much for your help, 

 

 

3 REPLIES 3
TomasAndersson
Solution Sage
Solution Sage

So each cell has a text field with operators such as "/" and "*"? There's no way for you to get the numeric data in separate columns, I suppose? That would make it easier.

It's probably possible to use a combination of FIND() (or SEARCH()), and MID() although it might become complicated depending on what data you have. 

Is it always a multiplication followed by a division? Does every cell start with "(("? If so, you can start at the third character and go to the asterisk (using FIND() and MID()), then multiply with the second number which you will find at the character after "*" but before "))" (using FIND() and MID()). And so on.  

If it's not the same structure the same principle as above applies, although you will have to adjust accordingly.

Thank you very much for your reply. 
They are no rules in the equations I have. they are different from eachother. 

Sorry but then I don't really know how to approach this problem. It would be too complicated to use my approach above.

Unless someone else is able to help you, and if you are able to export the column to Excel, you might use the approach described here: Excel function that evaluates a string as if it were a formula? - Super User

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.