Forum Discussion
pupadhya
Helper I
Helper ICustom Column
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 calc...
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.
ronrsnfld
Super User
Super UserYou 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.
pupadhyaHelper I
Helper IThank 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