Forum Discussion
GrahamHyde
4 years agoNew Member
Compare between 2 tables and highlight field changes
I have 2 tables and want to compare the values and show the row of the changed field and highlight the changed data in a summary table, as below; Table 1 ...
PaulDBrown
Community Champion
4 years agoIf you wish to use a measure (and identify rows missing from either table if so you wish), you can create dimension tables for the fields and set the model like this:
Then create a measure as follows:
Excluded from =
VAR T1 = COUNTROWS(EXCEPT(Table1, Table2))
VAR T2 = COUNTROWS(EXCEPT(Table2, Table1))
RETURN
SWITCH(TRUE(),
T1 = 1, "Not in Table 2",
T2 = 1, "Not in Table 1")
Then create a table visual with the fields from the dimension tables and add the measure: