Forum Discussion
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 ...
DataInsights
Super User
Super User
Try this calculated table. You can reverse the arguments in EXCEPT to identify what is in Table1 but not in Table2.
Difference Table = EXCEPT ( Table2, Table1 )
This is great, as long as the tables have the same columns, it creates a whole role with the changed data field. 👍 Thank you
How would I identify the changing field? Is it possible to embed an argument into the above to identify which field has the changed data? Or would it be somehow conditional formatted within the display of the table in the Report?
- DataInsights
You could create a flag that would identify any difference in the specific field (as compared to Table1), and then apply conditional formatting in a visual based on the flag. Would you be able to provide a screenshot of the expected result?