POWER BI - Formula is a string, need it calculating

[danieltock]

Hello,

I have a column that determines the formal needed, with a b and C within it.
A, B and C are independent columns.
When I substitute A,B abd C for the values it doesn't calculate the answer..

How can I fix this?

Example;

A=700
B = 36
C = 0

formula = A-(2XB)

Answer = 700-(2X36)

I want it to say 628.

Thanks,
Dan

 

[MarcelBeug]

In the query editor (Power Query or M):

let
    A=700,
    B=36,
    C=0,
    Formula = "A-(2*B)",
    Answer = Expression.Evaluate(Formula, [Formula = Formula, A=A, B=B])
in
    Answer

Expression.Evaluate

 

[danieltock]

Perfect! Thanks for your Help!

 

[citizenbh]

Another way:
Input Code in Advanced Editor in Power Query

let
    Query1 = #table({"A","B","C"},{{700, 36, 0}}),
    #"Added Custom" = Table.AddColumn(Query1, "Answer", each [A]-2*[B])
in
    #"Added Custom"