Forum Discussion
Compare two columns form different Table
HIi Anonymous , I am wondering why you need to the two tables in the data model. The Sub-Category contains all the data need to create the two visuals you have shown. If you are trying to add a reconciliation between the two tables, I would recommend using Power Query to compare the two tables. If there is an issue, then report this exception in Power BI.
If you want to compare using DAX, you will need to create Bridging Tables for Date and Category. These tables can then be joined to both tables. When they are joined, these table will apply filters to both tables. You will be able to compare the Sum of table 1 to Sum of table 2, and calculate a difference. Please watch the following GuyInACube video to understand this: Handling MULTIPLE fact tables in Power BI - YouTube