Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |