Forum Discussion

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