Solved: compare columns in two tables with same column nam... - Page 2

pxg08680 · ‎05-12-2017

Hi Everyone,

I have two tables A&B and have a column which is same in both the tables. I would like to compare the two columns and see if there is any difference between them and make a visual for that difference. both the tables are related using the data field.

For example, Column1 in TableA and Column1 in TableB are same and for getting the difference i tried tha dax query Diff= TableA[column1] - TableB[column1] and i have been getting errors and even if it executes I am getting incorrect values.

Can you help me with this...?

The solution is in real urgency....

Thank You

v-ljerr-msft · ‎05-15-2017

Hi @pxg08680,

According to your description above, you should be able to use the formula below to create a new measure and show it on the report to get the actual difference.

Diff =
SUM ( CommercialBuyIntentVisits[MetricValue] )
    - SUM ( CubeData[CommercialBuyIntentVisits] )

Regards

View solution in original post

compare columns in two tables with same column names

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly