topic Re: Evaluate mathematical equations / operators as text in DAX Commands and Tips

Evaluate mathematical equations / operators as text

Sorina — Wed, 14 Dec 2022 15:53:31 GMT

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,

Re: Evaluate mathematical equations / operators as text

TomasAndersson — Wed, 14 Dec 2022 17:58:57 GMT

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.

Re: Evaluate mathematical equations / operators as text

Sorina — Thu, 15 Dec 2022 07:07:45 GMT

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

Re: Evaluate mathematical equations / operators as text

TomasAndersson — Thu, 15 Dec 2022 08:36:15 GMT

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