Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Helper V
4 years ago
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...
Need Help
  • Sudhavi_84's avatar
    Sudhavi_84
    4 years ago

    I tried this but not working 

    Column = if(ISBLANK(LOOKUPVALUE(Table1[Records],Table1[Records],Table2[Received])),"No","Yes")

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

try merging tables as full join or building bridge table (which will containg non duplicate ids from both tables, you can use append in power query) and use one to many from bridge to both tables