Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to handle NULL value in custom column

HI, I need to to convert the below expression to power BI supported expression when I am going to add new column :   if(not isNULL(DOC_RECORD_KEY), DOC_RECORD_KEY, if(not isNULL(MSG_RECORD_KEY), ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous

 

You may refer to below DAX.  If it is not your case, please share your data sample and expected output.

Column =
IF (
    Table[DOC_RECORD_KEY] <> BLANK (),
    Table[DOC_RECORD_KEY],
    Table[GATEWAY_RECORD_KEY]
)

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

I am using the below DAX expression:

TRANSACTION_RECORD_KEY = if([DOC_RECORD_KEY] <> BLANK(),[DOC_RECORD_KEY], if([MSG_RECORD_KEY] <> BLANK(), [MSG_RECORD_KEY], [GATEWAY_RECORD_KEY]))

 

but getting the below error:

 

Argument '3' in IF function is required.

 

Please correct the above syntax.

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous

     

    I've tested your DAX expression with my data. It seems nothing wrong with it. It's better you can share your data sample or show the error screenshot.

    Column = IF([DOC_RECORD_KEY]<>BLANK(),[DOC_RECORD_KEY],IF([MSG_RECORD_KEY]<>BLANK(),[MSG_RECORD_KEY],[GATEWAY_RECORD_KEY]))

     

    Regards,

    Cherie