Forum Discussion
Solved
Data Modelling Relationship
Hi Experts, I have a very basic data model question, and struggling for it. I have a master data Table A which inludes all ID's , Regions and other details etc in it including duplicate ID's. I...
I tried this but not working
Column = if(ISBLANK(LOOKUPVALUE(Table1[Records],Table1[Records],Table2[Received])),"No","Yes")
Thanks All for quick reply
So ammend will work?
Because simply, I want to update new column in Table A as which ID's are in Table A and Which are not, like Yes or No
Again in Table B, I want to add one more column like which are in Table A and which are not in Table A as Yes or No please
Can I acheive this with out relating each other and using columns isn't it? if using columns what logic i need to use please so that I can use same logic in Table B too
use many to many relationship between a and b and create new calculated column using related function