Take text formulas from one column and apply row by row

[dobregon]

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!

[Chihiro · Accepted 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.

https://ssbi-blog.de/technical-topics-english/the-environment-concept-in-m-for-power-query-and-power...

[dobregon]

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!!

[Chihiro]

You are applying in DAX. It must be done in query editor using M function.

[dobregon]

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.