Table Value Comparison

[Sime]

Hi All,

I would like to compare the values of a column (same data) from 2 different tables and flag the unique values in a conditional column in the dataset so they can be filtered out.

Basically this is an example of what I am looking to do.

Table1.ColumnProject

12345

12346

12347

12348

Table2.ColumnProject

12345

12346

12347

12348

12349

12350

So the unique values in Table 2 (12349 & 12350) would be flagged as "New Projects" in a conditional column, and the reset would be "Existing Projects"

Can this be easily done?

Thanks.

[Samarth_18 · Accepted solution]

Hi @Sime ,

You can create a custom column in table 2 with below code:-

column =
VAR result =
    CALCULATE (
        FIRSTNONBLANK ( '__Table 1'[ColumnProject], 1 ),
        FILTER (
            ALL ( '__Table 1' ),
            '__Table 1'[ColumnProject] = '__Table 2'[ColumnProject]
        )
    )
RETURN
    IF ( ISBLANK ( result ), "Existing Project", "new project" )

Thanks,

Samarth

[Sime]

Thank you very much for your assistance @Samarth_18 .  This worked as anticipated. 

[freginier]

Hi 

it's very similare to this post : https://community.powerbi.com/t5/Desktop/IP-Address-Compare-and-Categorize/m-p/2282510#M827807

[Sime]

Hi @freginier,

Thank you for your response.  I am unable to get the solution you have posted above to work in my scenario as the 3rd argument appears to not accept the second table and [column] when creating the measure.

Any ideas where I am going wrong?

Ideally if I could perform this cross table comparison in the data set and add a calulated column that would be ideal.