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")

     

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
6 years ago

Hi sivashankr ,

 

My first guess is that your data is not actually null, but blank.

If you look at the table in Power Query, do these cells specifically say "null", or are the cells just blank?

 

Pete

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

    Hello BA_Pete ,

     

    The original table does not have nulls, I see the nulls after joing the 2 tables.

     

    Thanks,

    Siv

    • BA_Pete's avatar
      BA_Pete
      Icon for Super User rankSuper User
      6 years ago

      Hi sivashankr ,

       

      How about switching your IF statement around, something like:

       

      IF Customer <> null then "Y" else "N"

       

      Pete

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

        Still no luck Pete