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.
Hi all,
I want to create a calculated column that takes the text of the formula from other column and aplly it and give me te result.
As you can see in the column i have 2 columns of values (value 1 and value 2), then I have the text formula that need to be for each row (and need to be in text becasue someone in a front end could change the formula of calculation).
What I'm looking for is to create a calculated column that takes the "formula" from each row in the column formula and convert the text to a formula and give me the result of the formula.
Someone can help me?
Thanks in advance, Regards!
Solved! Go to Solution.
I really wouldn't recommend this approach, it is prone to error.
If you really must, you'd need to use Expression.Evaluate, combined with Record.Combine in query editor.
Add custom column.
=Expression.Evaluate([formula],Record.Combine({[_=_],#shared}))
Have a read of link for the concept used.
I really wouldn't recommend this approach, it is prone to error.
If you really must, you'd need to use Expression.Evaluate, combined with Record.Combine in query editor.
Add custom column.
=Expression.Evaluate([formula],Record.Combine({[_=_],#shared}))
Have a read of link for the concept used.
Thanks a lot @Chihiro but i'm trying to use the formula and i'm receiving the same error.. I'm sure that i'm doing something wrong or i have something to active in pwoerbi desktop or something.. becasue the query is in DAX and it seems wrong....
Can you help me what i'm doing wrong?
Thanks in advance and regards!!
oh, yes thats work now. thanks ajajaj it was saturday night.
And do you know if i can do queries like Lookupvalue / lookupvalue.. in the column formula and be apllied? Im trying but dont work but it is the solution so so much tank you.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |