The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a simple equation stored as text. Is there a straight forward manner in which I can convert this to the mathematical answer, instead of splitting the colums by the + delimeter, storing the split mumers as a numer and then creating a new colun to get what I want?
Solved! Go to Solution.
Expression.Evaluate with the column should do it
I have the same problem - I need to evaluate a math expression like:
((1038*1000000)/27011675) |
((32*1000000)/7152834) |
((1038*1000000)/27011675) |
((32*1000000)/7152834) |
Expression.Evaluate with the column should do it
soz hotchilli, but as a newbie to m i still can't get my head around it. Here is the query i have. It's gone through a number of steps to get to the below. How do I use Expression.Evaluate against the whole query, which for the sake of simplicity is called #"Nearly There". I want to Evaluate the entire column Entry Fee. Thanks in advance
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
82 | |
75 | |
53 | |
44 |
User | Count |
---|---|
136 | |
128 | |
78 | |
64 | |
63 |