Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Compare two columns

I need to compare two columns from two different tables which there is no relation between them but they both are connected to a fact table.   Table2------Key1-------- Facttable Facttable---Key2--...
Need Help
Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    Try: 

    Comparison measure =
SUMX (
    SUMMARIZE (
        Facttable,
        Table2[columnA],
        Table1[columnD],
        "@result", IF ( SUM ( Table2[columnA] ) = SUM ( Table1[columndD] ), 0, -1 )
    ),
    [@result]
)

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unfortunately I can't but I think the question is quite clear to answer 🙂

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous 

The question might seem clear to you, but we need more information. What data type are the columns you want to compare? what are the relationships between the tables? how are you hoping to display the result?...

Please read the following recommendations

How to get your question answered quickly