Multiplication of 2 variables into a new variable under consideration of a filter - how to do that?

[teinoB]

Hello 

I have:

Var 1 (numeric, column): satisfation scores between "1" to "10", plus "99" = no answer

Var 2 (numeric, column): wighting scores, numeric values for each row/individual between 0.1 and 1.9

I need:

NEW Var ( conditional new column, numeric), which has to contain:

Procuct "Var 1" * "Var 2", except where "Var 1 = 99" --> then "NEW Var" = null  

Can anybody describe me the most efficient way to create exactly this NEW Var in the data editor view?

Cheers,

teinoB

[amitchandak]

@teinoB , if they are two column

a new column in DAX

=

if([Var 1]  =99 , [Var 1] *[var 2] , blank())

[teinoB · Accepted solution]

@amitchandak 

Thanks. Yoursolution doesn't work, it produces an error "expected token: eof".

I tried a little bit around and came to this solution, it might probaly interest you:

NEW_Var=

if ([#"D05_1 : How satisfied are you?"]=99) then ("") else [weight]*[#"D05_1 : How satisfied are you?"]