Forum Discussion
sivashankr
Helper II
Helper IIplease 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...
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")
sivashankrHelper II
Helper II
ryan_mayu
Super User
Super UserThere 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
A Big Thank you ryan_mayu , Its working as expected.