So I am looking for some assistance creating a discrepancy report. I have two databases that should always be in sync with each other and I am going to be using PowerBI to spot check this. The databases are not completely matching but with some reference data I was able to create relationships to get what needs to be check into one visual. The end goal is to have one visual that disables all related rows that are out of sync with each other and possibly highlight the differences.
So what the visual looks like now is this, there is one more column that is not showing here that makes each of these rows unique. What I am looking to do is compare A1 to B1 and if they do not equal each other show the differences. I am assuming I can create a new table that stores only the differences and show the entire table in a visual? I've done some searching and I've seen recommendations on using DAX RELATED but I can't seem to get that working. Remember I have created reference data that is used to tie the two tables together. Any help is greatly appreciated! Thanks.
Thats a pretty interesting solution and it might work. I was able to get it all in the same visual by creating relationships between the two tables using reference data. How can I create the measure to pull in the value across two seperate tables?