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.
