Merging Data but adding Rows based on criteria? Relationship?

[Quemi]

Hi - New power query user; I am trying to set up an auto generated output based if a variable meets all specific criteria and if a variable is missing the criteria, then it is flagged. 

I have a minimum Required Result listing for each result obtained in a Within Each Group + Timepoint + Fruit). Group + Timepoint + Fruit is a static field (I will always know what results are expected at a minimum) 

My Data is driven by a Unique ID, this Unique ID can change Group + Timepoints + Fruit. 

Desired Output - If my Unique ID + Group + Timepoint + Fruit) is Missing one of the Required Results for that Section1(Group + Timepoint + Fruit) then I want it to Flag by Unique ID what is missing. For example:

For my Mid -Timepoint# 1 , I expect to have Banana and Orange fruits at a minimum. In my Table 2 "Results obtained" results for B1 = Mid -#1, I only have BAnana. 

I want Power query to Flag by Unique ID: B1 - Mid - #1 - Orange - Missing.  True can be for any matching values. 

challenge - I have a lot of unique IDs, Merging doesn't pull/ repeat the Unique ID. 

[PC2790]

Can you elaborate on your requirement. It is a little unclear on what your dataset looks like and with what you want the comparison to happen.

Please refer the below:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071...