Compare two columns in different tables to find non-matching and highlight text based on condition

[Anonymous]

I have these two tables (both loaded in Power Query) and displayed in Power BI as two Table visualizations:

Table name: Submissions

Name	Week Number
Trenton Espinoza	42
Anahi Johns	43
Max Gilbert	43
Jadyn Levine	44

Table name: Exceptions

Name	Week Number
Jadyn Levine	45
Trenton Espinoza	41
Anahi Johns	43
Katherine Waters	45
Jazlynn Mcclure	46

In Power BI, i want the result to be shown in the table, Submissions, by highlighting the names based on certain conditions.

Result shown in Power BI in the table, Submissions:

Name	Week Number
Trenton Espinoza	42
Anahi Johns	43
Max Gilbert	43
Jadyn Levine	44

The conditions for highlighting the names in the table Submissions:

1. The names in the Submissions table not in common with the names in the Exceptions table.

2. If the names in the Submissions table is common with the names in the Exceptions table, then check if the Week Number in the Submissions table is greater than the Week Number in the Exceptions table.

But i would like the font colour change in the same table, Submissions, visualization in the Power BI report.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Try to create a measure like this:

Measure = 
var _t1=ADDCOLUMNS('Submissions',"E-WN",CALCULATE(MAX('Exceptions'[Week Number]),FILTER(ALL(Exceptions),'Exceptions'[Name]='Submissions'[Name])))
var _t2=SUMMARIZE(FILTER(_t1,[E-WN]=BLANK()||[Week Number]>[E-WN]),[Name])
var _if=IF(SELECTEDVALUE('Submissions'[Name]) in _t2, "red")

return _if

Then apply conditional formatting to the name field.

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.