Custom Column

[pupadhya]

Hi All,

I am trying to create custom column and the desired result is = from my column 'Family' if the value is 787 then custom column should calculate (5.5*16)+(5.5*40) = it should show the calculation result and if not result 0, however I am not able to get the output by this :

([Family] = "787") * ((5.5 * 16) + (5.5 * 40)), it returns with error, can you please help.

[pupadhya]

Thank you for the reply, I did try the above formula, however value returns with 0 instead of showing the calculated result 

I want the end result of calculation which (5.5*16) + (5.5*40) = calculated value in the custom column

[ronrsnfld]

You do not show the family column in your example. My guess is that the data type in that column is number or whole number. You are checking in your logical statement if it is a text representation of a number. Hence the logical statement will return false. Power query is very aware of data types. Text does not equal number.

[pupadhya]

Thank you. this is my data type: 

My requirement is if family column returns with 787 then it should perform that calculation and place it in custom column and if family column has A320 then it should perform different calculation which I will improvise. Thanks

[ronrsnfld · Accepted solution]

As I wrote and suspected, your 787 appears to be a number. Change your if statement so that you are comparing to the number 787 and not to the text string 787.

[pupadhya]

Many thanks it worked.

[ronrsnfld]

Did you see the error message:  We cannot apply operator * to types Logical and Number.

Did you try editing your code to avoid that?

if ([Family] = "787") then ((5.5 * 16) + (5.5 * 40)) else 0