Calculation/ Equation in a single cell

[missmasturah]

There are cell values that read as 24*42+22 (eg).
I'd like to make sure the entire column is calculated. I am new to PowerBI, please help!

[d_gosbell]

---

@missmasturah wrote:

There are cell values that read as 24*42+22 (eg).
I'd like to make sure the entire column is calculated. I am new to PowerBI, please help!

---

So from that example, if those values are stored that way in your table (as 24*42+22) and you want to see the final result (eg. 1030) then you would either need to do that before loading the data into Power BI or you could maybe do it as a transform in your Query using Expression.Evaluate (see https://blog.crossjoin.co.uk/2015/02/06/expression-evaluate-in-power-querym/ ) . But I noticed that some of your data has extra apostrophies and double * characters which would probably cause errors if you did not clean them up before hand.

[Anonymous]

When you add a calculated column in Power Query the expression must be preceded with the equal sign "=". Otherwise, nothing gets computed, you're just entering text...