Forum Discussion

sivashankr's avatar
sivashankr
Icon for Helper II rankHelper II
6 years ago
Solved

please help on NULL Calculation

Hi Team, I have 2 tables 'Table A' and 'Table B'. I joined these 2 tables using M to 1 cardinality. Now the requirement is I've calculation "Valid Customer ?: if Table B.Customer is null then N e...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    sivashankr 

    There is no blank customer in table B and you are checking if there is any blank in table B

    I think Table A has a bigger customer group than table B. So you need to create that column in table A

    please try this

    validcustomer = 
VAR CUS=LOOKUPVALUE('Table B'[CUSTOMER],'Table B'[CUSTOMER],'Table A'[Customer])
return if(ISBLANK(CUS),"No","Yes")

     

  • sivashankr's avatar
    sivashankr
    Icon for Helper II rankHelper II
    6 years ago

    Hello ryan_mayu ,

    I tried with both ISBLANK and BANK.

    The problem what I see is the individual table does not have nulls. After I join the 2 tables and as a result of M-1 relationship I see nulls in Customer. Those are not either NULLS or BLANKS. As a result of this BLANK or ISBLANK or NULL, neither of them dont work.