Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi all,
I have a calculated column in Power BI - below image.
I need to return the calculation of these equations:
Is it any way to evaluate this calculations?
Thank you very much for your help,
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