Evaluate all results for specific patient
Hi All I have a list of patients and their various blood test results. Below is dummy data to futher explain what I need to evaluate. Name Measure Type Date Taken Result Measure Confilcts Jason Moor HbA1c 2018/06/13 10.3 Proximity Conflict Jason Moor HbA1c 2018/05/13 10.1 Proximity Conflict Jason Moor HbA1c 2019/10/13 7.6 David Mason HbA1c 2017/11/03 6.9 Proximity Conflict David Mason HbA1c 2019/12/01 6.6 David Mason HbA1c 2017/10/03 8.6 Proximity Conflict I need a dax function that will evaluate HbA1c results for a patient and flag any results that were taken within 2 months of each other as Proximity Conflict. In the table above, Jason Moor has 3 results, 2 of which are taken within a month of each other. I need to flag both of them as Proximity Conflicts because of this. I tried using the below calculated column: Measure Conflicts = SWITCH( TRUE(), 'Measure'[Measure Type] = "HbA1c" && 'Measure'[Date] <= 'Measure'[HbA1c DateAdd]*, "Proximity Conflict (A1c)") *'Measure{HbA1c DateAdd] = IF('Measure'[Measure Type] = "HbA1c", DATE(YEAR('Measure'[OccurrenceDate]),MONTH('Measure'[OccurrenceDate])+2 ,DAY('Measure'[OccurrenceDate]))) What this calculated column does is evaluate only the row. I need it to evaluate all results for the measure type of HbA1c for the specific patient. Please help.