Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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.