Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculation/ Equation in a single cell

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!

 

 

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    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...
  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago
    Anonymous 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.