Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi,

I am using the below code:

if ([DOC_RECORD_KEY] <> "NULL", [DOC_RECORD_KEY],
if([DOC_RECORD_KEY] <> "NULL", [DOC_RECORD_KEY], [GATEWAY_RECORD_KEY]
)
)

but getting 'Token RightParen Expected' error. So please correct me in this case.

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 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
    8 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
      8 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