Forum Discussion
Solved
DAX compare data from different tables
I am trying to find differences between two tables carrying the same data but from different sources. I need to find differences. Can anyone please support! Table 1: Employee_Code Salary_Month...
While this can be solved in DAX, the cleaner way to do it is to transform your data so that you have a snowflake schema with two fact tables. What you want to do is create a tables with distinct customer code then link this to both tables, as you have done with the calendar tables. You will also need to delete the relationship between the two fact tables.
This is by far the best way to solve this, it is possible with measures or with a different model.
You may change the relationships and then use the measure Difference1. Attached the sample file for your reference.
Regards,
Cherie
I tried but no change in result.:smileysad: